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.

N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879 N7780FDuquette Stephen R · Fenton, MIS/N 15063880 N7782FLewis Wayne · Martin, TNBuilt 1966 · S/N 15063882 N7783FMiller Patrick G · Homer, AKBuilt 1966 · S/N 15063883 N7784FSelf Edwin C · Columbia, TNBuilt 1966 · S/N 15063884 N7788FGerig David J · Woodburn, INBuilt 1966 · S/N 15063888 N7789FSutton George R · Big Bear City, CABuilt 1966 · S/N 15063889 N7792FBas Part Sales LLC · Greeley, COS/N 15063892 N7794FWhitman Larry C · Hinesville, GABuilt 1966 · S/N 15063894 N7796FLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15063896 N7799FGeese Douglas A · Churubusco, INBuilt 1966 · S/N 15063899 N7800FS & L Aviation LLC · Ashland, OHS/N 15063900 N7806FTaheri Jay · Ridgewood, NJBuilt 1966 · S/N 15063906 N7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1966 · S/N 15063907 N7813FUp And Away Aviation LLC · Poughkeepsie, NYBuilt 1966 · S/N 15063913 N7821FKoch Leasing LLC · Campbellsville, KYBuilt 1966 · S/N 15063921 N7823FJackson Larry T · Maplesville, ALS/N 15063923 N7828FTaylor Andrew G · Lexington, KYBuilt 1966 · S/N 15063928 N7831FHallmark Ryan M · Vidor, TXBuilt 1966 · S/N 15063931 N7838FMcdonald Air Services LLC · Saint Johns, MIBuilt 1966 · S/N 15063938 N7843FDas Manoj Kumar · Buffalo Grove, ILBuilt 1966 · S/N 15063943 N7844FWise Jonathan Keith · Eden, NCS/N 15063944 N7846FGrossman Steven · Seven Valleys, PAS/N 15063946 N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951 N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953 N7855FSmith Joshua B · Kenai, AKS/N 15063955 N7856FFitzgibbon Patrick D · Waterloo, WIBuilt 1966 · S/N 15063956 N7858FShelley Tiffany · Chandler, AZFirst renewal noticeS/N 15063958 N7860FVahary David J · Portage, INBuilt 1966 · S/N 15063960 N7861FFranks Bryan S · Camarillo, CABuilt 1966 · S/N 15063961 N7874FLynch Cody J · Stanwood, WAS/N 15063974 N7875FDeffendall Cathy S · Florissant, MOBuilt 1966 · S/N 15063975 N7876FSavedge A Randolph · Surry, VABuilt 1966 · S/N 15063976 N7877FCosta Air Service LLC · Painted Post, NYBuilt 1966 · S/N 15063977 N7881FNorman Robert A · Zanesville, OHBuilt 1966 · S/N 15063981 N7887FSwearingin Curtis A · Carrollton, MOBuilt 1966 · S/N 15063987 N7890FScholz Francis M · Atchison, KSBuilt 1966 · S/N 15063990 N7893FBrowett Donald · Independence, MOBuilt 1966 · S/N 15063993 N7895FBrock Michael G · New Lenox, ILBuilt 1966 · S/N 15063995 N7897FOneonone Flight Training LLC · Hagerstown, MDBuilt 1966 · S/N 15063997 N7900FValley Wine Exports LLC · Rollingbay, WABuilt 1966 · S/N 15064000 N7903FSmith Troy D · Arcadia, INBuilt 1966 · S/N 15064003 N7909FK-Air Inc · Egg Harbor, WIBuilt 1966 · S/N 15064009 N7914FPrater Stewin W · Chillicothe, OHBuilt 1966 · S/N 15064014 N7920FFalk William P · Milford, CTBuilt 1966 · S/N 15064020 N7926FRandolph Wallie R · Nebo, NCBuilt 1966 · S/N 15064026 N7928FCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1966 · S/N 15064028 N7934FKay Bennie L · Brigham City, UTS/N 15064034 N7935FB&R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 15064035 N7937FSomes Brad H · Goddard, KSBuilt 1966 · S/N 15064037

Back to Cessna 150F