Skip to content

Registered aircraft · 976

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 ('2071816')
  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 ('2071816')
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.

N2921JAndrews University · Berrien Springs, MIBuilt 1966 · S/N 15065721 N2922JStecklein Brittney R · Overland Park, KSBuilt 1966 · S/N 15065722 N2922SWard Aviation · Marysville, OHBuilt 1967 · S/N 15066822 N2923SHamann John · Orlando, FLBuilt 1967 · S/N 15066823 N2924JPiscoya Thomas G · Anchorage, AKBuilt 1966 · S/N 15065724 N2925SSmolik Amanda · Ponder, TXBuilt 1967 · S/N 15066825 N2926SFord John M · Rock Stream, NYS/N 15066826 N2928JVu Huy T · San Diego, CABuilt 1966 · S/N 15065728 N2928SDoubler Endeavors LLC · Orlando, FLBuilt 1967 · S/N 15066828 N2929STerrell Aviation Inc · Terrell, TXS/N 15066829 N2930JTetil Nicholas M · Fairgrove, MIBuilt 1966 · S/N 15065730 N2931JSmith William T · Fort Payne, ALBuilt 1966 · S/N 15065731 N2932SRutoski Mary Ann · Jordan, MNBuilt 1967 · S/N 15066832 N2933SHarry Kevin M · Salisbury, NCBuilt 1967 · S/N 15066833 N2935JSmith Stanley P · Athens, ALBuilt 1966 · S/N 15065735 N2936JElkins James D · Salem, ORBuilt 1966 · S/N 15065736 N2937JSchumann Jennifer Pauline · Conroe, TXBuilt 1966 · S/N 15065737 N2941JReilly Isabella · Prescott, AZBuilt 1966 · S/N 15065741 N2942JRegistered aircraftBuilt 1966 · S/N 15065742 N2942SEvenson Don C · Moorhead, MNS/N 15066842 N2944JThomas Edward R · Piney Flats, TNS/N 15065744 N2944SChartrand Robert J · Brimley, MIBuilt 1967 · S/N 15066844 N2946SFreed Michael · Sylmar, CABuilt 1967 · S/N 15066846 N2947JMaggio Anthony M · Harbor City, CABuilt 1966 · S/N 15065747 N2948JSale Reported · Ruston, LASale reportedBuilt 1966 · S/N 15065748 N2949SRegistered aircraftBuilt 1967 · S/N 15066849 N2950JRunway Aviation Flight Training USA Corp · Rockwall, TXS/N 15065750 N2950SJohnson Aviation LLC · Middleton, IDS/N 15066850 N2951JJohnston Robert G · Rose Hill, KSBuilt 1966 · S/N 15065751 N2953SKelley Mark · El Granada, CABuilt 1967 · S/N 15066853 N2955JAguilar Honorio Alejandro · Anna, TXBuilt 1966 · S/N 15065755 N2956JDecker Kathy A · Greenville, MIBuilt 1966 · S/N 15065756 N2956SPuder Karen D · Lenzburg, ILBuilt 1967 · S/N 15066856 N2957JMcmahon Thomas G · Hoffman Estates, ILBuilt 1966 · S/N 15065757 N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759 N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859 N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760 N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860 N2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861 N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863 N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864 N2967SJordan Jason A · Portland, MEBuilt 1967 · S/N 15066867 N2968SVoyles Robert L · Seymour, TNBuilt 1967 · S/N 15066868 N2970JFlorida State College At Jacksonville · Jacksonville, FLBuilt 1966 · S/N 15065770 N2970SDouble Circle LLC · Bosque Farms, NMBuilt 1967 · S/N 15066870 N2972JN2972j LLC · Nacogdoches, TXBuilt 1966 · S/N 15065772 N2972SMaxwell Lance C · Saint Charles, ILBuilt 1967 · S/N 15066872 N2973JHoyos Nicholas · Weston, FLBuilt 1966 · S/N 15065773 N2976JHanson Larry R · Buffalo, WYBuilt 1966 · S/N 15065776 N2976SSapp Jarrell · Sale City, GAS/N 15066876

Back to Cessna 150G