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.

N2123QMellor James F · Spanish Fork, UTS/N 177RG0523 N2124QBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 177RG0524 N2125QRizzuto Nunzio Stephen · Decatur, ALBuilt 1974 · S/N 177RG0525 N2126QDurable Industrial Finishing Co Inc · Tucker, GABuilt 1974 · S/N 177RG0526 N2129QEarnshaw Larry L · Erie, COBuilt 1974 · S/N 177RG0529 N2131QImhoff Donald W · Baton Rouge, LABuilt 1974 · S/N 177RG0531 N2132QHawk Aviation Inc · Chesapeake Beach, MDBuilt 1974 · S/N 177RG0532 N2134QLuft Aviation Inc · Wilmington, DEBuilt 1974 · S/N 177RG0534 N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536 N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537 N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540 N2141QNeuman Allen D · Sanger, TXS/N 177RG0541 N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542 N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545 N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546 N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548 N2149QRegistered aircraftBuilt 1974 · S/N 177RG0549 N2152QGeorge R Jones Jr · Dallas, TXBuilt 1974 · S/N 177RG0552 N2155QFellows Walter · Prineville, ORBuilt 1974 · S/N 177RG0555 N2156QBowers Jackie M · Elmer, NJBuilt 1974 · S/N 177RG0556 N2161QSalty Dawg Aircraft Inc · Gasport, NYBuilt 1974 · S/N 177RG0561 N2166QLiberty Partners Inc · Okmulgee, OKBuilt 1974 · S/N 177RG0566 N2169QWhite Beth A · Keene, NHBuilt 1974 · S/N 177RG0569 N2170QSkowronski Steven · Demotte, INBuilt 1974 · S/N 177RG0570 N2172QLehr Kenneth Edward Trustee · Sacramento, CABuilt 1974 · S/N 177RG0572 N2174QRothrock Brandon E · Los Angeles, CABuilt 1974 · S/N 177RG0574 N2176QHawkins George W IV · Kansas City, KSBuilt 1974 · S/N 177RG0576 N2179QHuston Jeffrey D · Haslet, TXBuilt 1974 · S/N 177RG0579 N217AFSouth 40th Rentals LLC · Jamul, CAS/N 177RG1011 N217JLGallup Shelley P · Monterey, CABuilt 1971 · S/N 177RG0140 N2183QMcpherson Douglas G · Pennellville, NYS/N 177RG0583 N2184QMallette Carl L · Knoxville, TNBuilt 1974 · S/N 177RG0584 N2185QCarlson Bruce D · Umatilla, ORS/N 177RG0585 N2186QBlue Streak LLC · Athens, GAS/N 177RG0586 N2192QAdams Kenny G · Phelan, CABuilt 1974 · S/N 177RG0592 N2193QGerber John T · Lumberton, NCBuilt 1974 · S/N 177RG0593 N2194QMartin Dennis E · Oconto, WIBuilt 1974 · S/N 177RG0594 N2195QWatters Claytus James · Magnolia, TXBuilt 1974 · S/N 177RG0595 N2196QGillette William · Northbrook, ILBuilt 1974 · S/N 177RG0596 N2197QCarnahan Benjamin J · Grass Valley, CAS/N 177RG0597 N21EBSunview Flying Service LLC · Jordan, NYBuilt 1974 · S/N 177RG0589 N224MBBarker Ballard M · Satellite Beach, FLBuilt 1976 · S/N 177RG0935 N226DMFewel Lance E · Lake Oswego, ORBuilt 1976 · S/N 177RG0929 N232CBLight Air Development LLC · Helena, MTBuilt 1976 · S/N 177RG0998 N2516VGreat Adventure Sailing Vessell LLC · Greer, SCBuilt 1974 · S/N 177RG0601 N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604 N2533VHasselvander Brian K · Columbia, MSBuilt 1974 · S/N 177RG0605 N2535VRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1974 · S/N 177RG0606 N2538VDavidson Joel R · Granville, NYS/N 177RG0607 N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617

Back to Cessna 177RG