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.

N1878QKachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 177RG0278 N1880QNewby Patrick · Mentor, OHBuilt 1972 · S/N 177RG0280 N1883QMitchell Philip J · Arlington, TXS/N 177RG0283 N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285 N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287 N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288 N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289 N1893QSauk Prairie Aviators LLC · Merrimac, WIBuilt 1972 · S/N 177RG0293 N1897QGuadarrama Joe R · Vacaville, CABuilt 1972 · S/N 177RG0297 N1899QAlvord Jeffrey C · Tucker, GABuilt 1972 · S/N 177RG0299 N1899SBuon Volo LLC · Queen Creek, AZBuilt 1971 · S/N 177RG0045 N189DCWorthan Gary T Trustee · Storm Lake, IABuilt 1976 · S/N 177RG0927 N1903QMatter Gregory · Sherman, TXBuilt 1972 · S/N 177RG0303 N1907QSimmons Marilyn K · Wilmington, DEBuilt 1972 · S/N 177RG0307 N1909QHarper Donald W · Odenton, MDBuilt 1972 · S/N 177RG0309 N1917QMeester Mark L · Intl Falls, MNBuilt 1972 · S/N 177RG0317 N1919QErickson Bernard L · Moses Lake, WABuilt 1972 · S/N 177RG0319 N1922QLendor Jason C · Chicago, ILBuilt 1972 · S/N 177RG0322 N1923QHansen Eric P Trustee · Arlington, WABuilt 1973 · S/N 177RG0323 N1925QReagan Amber J · Mcalester, OKBuilt 1973 · S/N 177RG0325 N1928QWhite David D · Arcata, CABuilt 1973 · S/N 177RG0328 N1932QHogan James C DBA · Cameron Park, CABuilt 1973 · S/N 177RG0332 N1939QGustafson Keith W · Waleska, GABuilt 1973 · S/N 177RG0339 N1943QLeonard Joseph · Bohemia, NYBuilt 1973 · S/N 177RG0343 N1944QHenry Peter S · Olympic Valley, CABuilt 1973 · S/N 177RG0344 N1945QSmith Thomas E Jr · Chino Hills, CABuilt 1973 · S/N 177RG0345 N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346 N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347 N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564 N1948QHorsley Luther J · Midland, ORS/N 177RG0348 N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350 N1963QJohnson Clinton B · Alpharetta, GABuilt 1973 · S/N 177RG0363 N1964QAction Air LLC · Missoula, MTBuilt 1973 · S/N 177RG0364 N1969QKalis Jeffrey J · Sparta, MIBuilt 1973 · S/N 177RG0369 N1972QFlying Associates Inc · Hudson, WIBuilt 1973 · S/N 177RG0372 N1974QMag Air LLC · West Miami, FLBuilt 1973 · S/N 177RG0374 N1977QPeabody Jeffery L · Vinemont, ALBuilt 1973 · S/N 177RG0377 N1986QMccaffrey Fr Joseph R · Pulaski, PABuilt 1973 · S/N 177RG0386 N1989QDelta Bravo Aviation · Byron Center, MIBuilt 1973 · S/N 177RG0389 N1991QJohnny Becker LLC · Helotes, TXS/N 177RG0391 N1993QCasper Aire Inc · Saint Cloud, FLBuilt 1973 · S/N 177RG0393 N1995QHooper Jonathan P · Andrews, NCBuilt 1973 · S/N 177RG0395 N1999QGentry Harry J · Canton, OHBuilt 1973 · S/N 177RG0399 N19JRKyle Agne · Greensboro, NCBuilt 1973 · S/N 177RG-0314 N19MUGarrett Jack H · Grandview, TXS/N 177RG0099 N2001QMutschler Thomas A · Belle Vernon, PABuilt 1973 · S/N 177RG0401 N2002QPrecision Aero LLC · Wilmington, DEBuilt 1973 · S/N 177RG0402 N2003Q177rg LLC · Dover, DEBuilt 1973 · S/N 177RG0403 N2005QCoon Roger E · Springtown, TXFirst renewal noticeBuilt 1973 · S/N 177RG0405 N2006QFarr Brad L · Uvalde, TXBuilt 1973 · S/N 177RG0406

Back to Cessna 177RG