Skip to content

Registered aircraft · 1,065

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

N6452FRobinson Bruce · Salinas, CABuilt 1966 · S/N 15063052 N6456FAmb Parnell G · Portland, NDBuilt 1966 · S/N 15063056 N6457FPepper Christopher W · Memphis, TXBuilt 1966 · S/N 15063057 N6458FLejcar Matthew J · Mesa, AZBuilt 1966 · S/N 15063058 N6460FThorton Rod W · Barrington, RIBuilt 1966 · S/N 15063060 N6465FBurris Donald E · Lawton, OKS/N 15063065 N6466FGee Ryan S · Luverne, MNBuilt 1966 · S/N 15063066 N6470FMatuska James H · Deary, IDBuilt 1966 · S/N 15063070 N6474FDodd Michelle J · Riverton, KSBuilt 1966 · S/N 15063074 N6476FKnowles Brian Thomas · Windsor, NCBuilt 1966 · S/N 15063076 N6480FHaithcock Stephen · Oxnard, CABuilt 1966 · S/N 15063080 N6481FWood James N · Samson, ALBuilt 1966 · S/N 15063081 N6483FRegistration Pending · Seattle, WARegistration pendingS/N 15063083 N6484FGrant Clinton A · Portage Des Sioux, MOS/N 15063084 N6488FLee Michael R · Kelso, WABuilt 1966 · S/N 15063088 N6492FSkywagon Aero LLC · Wilmington, DES/N 15063092 N6500FMoore Howard W · Camden, TNBuilt 1966 · S/N 15063100 N6501FHoward James S · Arlington, TXS/N 15063101 N6505FCoffman Curtis M · Lakeside, ORBuilt 1966 · S/N 15063105 N6506FMdowell Pilot Service LLC · South Hutchinson, KSS/N 15063106 N6510FPrice Gregory L · Kyle, TXBuilt 1966 · S/N 15063110 N6517FSnouffer Robert E · Mountain Grove, MOBuilt 1966 · S/N 15063117 N6523FMatthews Mark · Brandon, MSBuilt 1966 · S/N 15063123 N6526FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15063126 N6529FRising Aviation LLC · Prairieville, LABuilt 1966 · S/N 15063129 N6530FRaw Racing Inc · Puyallup, WABuilt 1966 · S/N 15063130 N6533FMoore William H III · Deer Park, WABuilt 1966 · S/N 15063133 N6534FAnderson Ted E · Petal, MSBuilt 1966 · S/N 15063134 N6539FSweitzer Merle E · Felton, PABuilt 1966 · S/N 15063139 N6543FJackson Road Flyers · Wayne, MIS/N 15063143 N6554FMendonca Jimmy · Caddo Mills, TXBuilt 1966 · S/N 15063154 N6555FThompson Jeffrey L · Scandia, KSS/N 15063155 N6558FMolek Jon · Warren, OHS/N 15063158 N6561FWings Aero LLC · Zeeland, MIBuilt 1966 · S/N 15063161 N6564FBradley John · Edgewood, NMBuilt 1966 · S/N 15063164 N6566FOdekirk David C · Watertown, WIBuilt 1966 · S/N 15063166 N6569FWise Joe · Kilgore, TXBuilt 1966 · S/N 15063169 N6570FMykland Bennett · Graham, WABuilt 1966 · S/N 15063170 N6575FBarnett Joe N · Siloam Springs, ARBuilt 1966 · S/N 15063175 N6579FPratka Rhett A · Pleasanton, TXBuilt 1966 · S/N 15063179 N6580FLawson Jeremiah · Lunenburg, VTBuilt 1966 · S/N 15063180 N6582FHemmatyar Nabi Z · Malibu, CAS/N 15063182 N6583FButterfield Rory A · Milan, NMS/N 15063183 N6585FBrouse Dan T · Magnolia, TXBuilt 1966 · S/N 15063185 N6586FLunar Aviation LLC · Tahlequah, OKBuilt 1966 · S/N 15063186 N6587FJones Aviation Inc · Biggs, CABuilt 1966 · S/N 15063187 N6589FRush Paul E · Highland, KSS/N 15063189 N6590FMapes Peter B · Oscoda, MIBuilt 1966 · S/N 15063190 N6595FRose Edward · Brooklyn, NYBuilt 1966 · S/N 15063195 N6596FTrenholm Daniel L · Eagan, MNBuilt 1966 · S/N 15063196

Back to Cessna 150F