Skip to content

Registered aircraft · 788

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2073709', '2073710')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2073709', '2073710')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2007QHopkins William · Reno, NVS/N 177RG0407 N2008QCoulter Dennis · Lincoln, CABuilt 1943 · S/N 177RG0408 N2009QTranby Wayne A · Fargo, NDBuilt 1973 · S/N 177RG0409 N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410 N2011QManzo Mario A · Sacramento, CAS/N 177RG0411 N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412 N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414 N2015QMeyer Gregory L · Lebanon, PABuilt 1973 · S/N 177RG0415 N2017QGraves William D · Rock Hill, SCBuilt 1973 · S/N 177RG0417 N2021QHamilton Gregory J · Avon Lake, OHBuilt 1973 · S/N 177RG0421 N20221Ohair Mark O · Lampasas, TXFirst renewal noticeBuilt 1972 · S/N 177RG0273 N2025QNelson Gerald E · Burlington, WABuilt 1973 · S/N 177RG0425 N2027QDettmering Todd J · Menomonee Falls, WIBuilt 1973 · S/N 177RG0427 N2028QKrystina Tharp · Rialto, CABuilt 1973 · S/N 177RG0428 N2029QAshley Steven T · Central City, KYBuilt 1973 · S/N 177RG0429 N2031QLight Sport Aeronautics LLC · Brooklet, GAS/N 177RG0431 N2035QDonn E Mount Realty Inc · Titusville, FLBuilt 1973 · S/N 177RG0435 N2036QEtling Carl G · Edgar, NEBuilt 1973 · S/N 177RG0436 N2041QGarcia Cameron A · Yukon, OKBuilt 1973 · S/N 177RG0441 N2043QAnderson Michael R · Bedford, INBuilt 1973 · S/N 177RG0443 N2044QWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1973 · S/N 177RG0444 N2047QMeersma Montgomery D · Atlanta, GABuilt 1973 · S/N 177RG0447 N2049QDdv Equipment Leasing LLC · Cheyenne, WYBuilt 1973 · S/N 177RG0449 N2051QErwa Mohamed · Cedar Park, TXBuilt 1973 · S/N 177RG0451 N2052QCentral Virginia Aviation Inc · Petersburg, VABuilt 1973 · S/N 177RG0452 N2054QLawrence Bradley R · Payson, AZBuilt 1974 · S/N 177RG0454 N2056QElecsys LLC · San Marcos, CABuilt 1973 · S/N 177RG0456 N2058QN2058q LLC · Washington, PABuilt 1973 · S/N 177RG0458 N2060QAlvarez Manuel B · Linden, MIBuilt 1973 · S/N 177RG0460 N2063QAv8ors LLC · Port Orange, FLBuilt 1973 · S/N 177RG0463 N2072QMeenk Regna L · Las Vegas, NVS/N 177RG0472 N2074QStuzenski Patrick E · Shoreham, NYS/N 177RG0474 N2075QHaugen'S Hangar LLC · Williston, NDS/N 177RG0475 N2076QGreen Jason A · Omaha, NEBuilt 1973 · S/N 177RG0476 N2077QDirks Darrel · Marienthal, KSBuilt 1973 · S/N 177RG0477 N2079QMkk Pilots LLC · Media, PABuilt 1974 · S/N 177RG0479 N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483 N2086QMillner Paul · Berkeley, CABuilt 1974 · S/N 177RG0486 N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489 N2090QRawls Mike E · New Waverly, TXS/N 177RG0490 N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106 N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491 N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499 N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888 N20AXHehmann Richard J · Belleville, ILS/N 177RG1160 N2105QBarreto Daniel · Enterprise, ALBuilt 1974 · S/N 177RG0505 N2112QSoloman Michael Glenn · Dallas, GABuilt 1974 · S/N 177RG0512 N2117QGately Brian · Brooklyn, NYBuilt 1974 · S/N 177RG0517 N211WTBetelgeuse Aviation LLC · Houston, TXBuilt 1978 · S/N 177RG1321 N2121QSchardt James A · Garden Valley, CABuilt 1974 · S/N 177RG0521

Back to Cessna 177RG