Skip to content

Registered aircraft · 1,439

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

N6289KPitcock Randall · Farwell, TXBuilt 1975 · S/N 15077627 N6296KMclean Lachlan · North Creek, NYBuilt 1975 · S/N 15077629 N6299KMarco Aviation Club Corp · Naples, FLBuilt 1975 · S/N 15077630 N63000Jet Boy LLC · Henderson, NVBuilt 1975 · S/N 15077036 N63001Rbv Aviation And Cattle LLC · Kalispell, MTS/N 15077037 N63002Nolt Shannon E · East Earl, PAS/N 15077038 N63003Newell Rory H · Warner Springs, CAS/N 15077039 N63006Registration Pending · Snohomish, WARegistration pendingBuilt 1975 · S/N 15077042 N63008Wheaton Eric J · Gig Harbor, WAS/N 15077044 N6300KCash Richard W · Bossier City, LABuilt 1975 · S/N 15077631 N63033Baumer Luke R · Pittsboro, INS/N 15077051 N63036Registered aircraftS/N 15077052 N63040Bullington Michael D · Spring Hill, TNBuilt 1975 · S/N 15077056 N63042Ting Chih-Wei · Tracy, CABuilt 1975 · S/N 15077058 N63046Lindholm Michael D · Anchorage, AKS/N 15077060 N63047Ggf Inc · Jacksonville, ARS/N 15077061 N63051Moss Ronald J · Hamer, IDBuilt 1975 · S/N 15077065 N63053Claeys John T · Blue Grass, IABuilt 1975 · S/N 15077066 N63057Guerra Enmanuel M · Weirsdale, FLBuilt 1975 · S/N 15077070 N63062Cade Richard G · Lopez Island, WABuilt 1975 · S/N 15077074 N63066Rench Eugene G · Owosso, MIBuilt 1975 · S/N 15077075 N63074Charlton Jeremiah · Rockford, ILBuilt 1975 · S/N 15077082 N63079Ark Aerospace LLC · Fort Walton Beach, FLBuilt 1975 · S/N 15077087 N63091Hobbs Kole T · Greenville, TXBuilt 1975 · S/N 15077098 N63092Lozano Jorge L · Miami, FLS/N 15077099 N63095Boyle Daniel K · Llano, TXBuilt 1975 · S/N 15077101 N63114Rgw Aviation LLC · Wilmington, DEBuilt 1975 · S/N 15077113 N63120Dean James J · Tampa, FLBuilt 1975 · S/N 15077116 N63121Aba Contractors Inc · Arcadia, OKBuilt 1975 · S/N 15077117 N63122Registered aircraftBuilt 1975 · S/N 15077118 N63125Registration Pending · Burnsville, MNRegistration pendingBuilt 1975 · S/N 15077121 N63126Aero Marine Inc · Westland, MIBuilt 1975 · S/N 15077122 N63132Ha Peter · Eastvale, CABuilt 1975 · S/N 15077124 N63138Sport Flyer Service LLC · Katy, TXBuilt 1975 · S/N 15077130 N63149Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 15077138 N63154Burleson James G · Grand Prairie, TXBuilt 1975 · S/N 15077142 N63155Morten David J · Larimore, NDS/N 15077143 N63157Tadres Abanob Y · Antioch, TNBuilt 1975 · S/N 15077145 N63165Eagle Eye Aviation LLC · Mccomb, MSBuilt 1975 · S/N 15077150 N63169Spinola Hernandes M · Homestead, FLBuilt 1975 · S/N 15077153 N63179Fetch Carl Jr · Monongahela, PABuilt 1975 · S/N 15077157 N63180Hall Thomas E · Sylvia, KSBuilt 1975 · S/N 15077158 N63181Wild Blue Flight LLC · Ellensburg, WABuilt 1975 · S/N 15077159 N63186Branche Mitchell J · Winter Haven, FLBuilt 1975 · S/N 15077164 N63197Deangelis Kristopher M · Las Vegas, NVBuilt 1975 · S/N 15077166 N63198White Hayden · Lees Summit, MOBuilt 1975 · S/N 15077167 N63199Winfred & Waters LLC · Georgetown, TXBuilt 1975 · S/N 15077168 N6319KStemmer Kenneth Edward · Palm Desert, CABuilt 1975 · S/N 15077641 N63205Bagwell Robert B · Sequim, WABuilt 1975 · S/N 15077173 N63207Two Star Maritime LLC · Fremont, CABuilt 1975 · S/N 15077175

Back to Cessna 150M