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.

N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640 N7042FKadlecovic Martin · Prescott, AZS/N 15063642 N7044FHanson Mike D · Vinton, IABuilt 1966 · S/N 15063644 N7047FVanderlei Lowell B · Springfield, SDBuilt 1966 · S/N 15063647 N7053FAce Aeromotive Inc · Miami, FLS/N 15063653 N7058FTechnical Education Services Inc · Virginia Beach, VAS/N 15063658 N7066FLamb Barry J · Moran, KSBuilt 1966 · S/N 15063666 N7068FAndrew David N · Manhattan, ILBuilt 1966 · S/N 15063668 N7070FDaub David M · Sealy, TXBuilt 1966 · S/N 15063670 N7072FMiller Richard M · New Galilee, PABuilt 1966 · S/N 15063672 N7073FBushby David R · Barnesville, GABuilt 1966 · S/N 15063673 N7075FGillette Timothy R · Ipswich, MABuilt 1966 · S/N 15063675 N7081FHayes Travis · Harrisonville, MOBuilt 1966 · S/N 15063681 N7082FBuchanan Walter C · Yuma, AZBuilt 1966 · S/N 15063682 N7086FCooley Dennis Andrew · Wasilla, AKBuilt 1966 · S/N 15063686 N7087FParnell Don E · Alexandria, LAS/N 15063687 N7088FVander Mey Thomas H · Aitkin, MNBuilt 1966 · S/N 15063688 N708CCOlivier Seth N · Baskin, LABuilt 1966 · S/N 15063262 N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693 N7094FLarsen Gary A · Honolulu, HIBuilt 1966 · S/N 15063694 N7096FJanuary Lynn E · Mcpherson, KSFirst renewal noticeBuilt 1966 · S/N 15063696 N7098FBumps Stephen D · Gilead, MEBuilt 1966 · S/N 15063698 N7099FMiles Del R · Blackfoot, IDBuilt 1966 · S/N 15063699 N709LCN709lc LLC · Orange, TXBuilt 1966 · S/N 15063937 N7107FPoe John B Jr · Port Orange, FLBuilt 1966 · S/N 15063707 N7112FHurst Richard H · Lometa, TXBuilt 1966 · S/N 15063712 N7114FWernecke Thomas C · Southfield, MIBuilt 1966 · S/N 15063714 N7119FCossette Bradley J · Detroit Lakes, MNBuilt 1966 · S/N 15063719 N711WFSmith Lot P · Grangeville, IDBuilt 1966 · S/N 15063720 N7121FMartin Tricia · Tulsa, OKBuilt 1966 · S/N 15063721 N7125FWerner Angela S · Grand Forks, NDBuilt 1966 · S/N 15063725 N7129FDavis Clint H · Paola, KSBuilt 1966 · S/N 15063729 N7130FRicker Gary L · Greeneville, TNS/N 15063730 N7131FSchoch Brayden · Fort Pierce, FLBuilt 1966 · S/N 15063731 N7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1966 · S/N 15063733 N7134FMejean Kenneth R · Brandon, FLBuilt 1966 · S/N 15063734 N7135FMiller Joseph A · Amissville, VABuilt 1966 · S/N 15063735 N7140FLogan Gregory A · Chouteau, OKS/N 15063740 N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746 N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747 N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748 N7150FTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 15063750 N7154FFenton Richard Trustee · Mckinleyville, CABuilt 1966 · S/N 15063754 N7155FJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15063755 N7159FBrooks James · West Liberty, OHBuilt 1966 · S/N 15063759 N7160FFoxy Bankins LLC · Hobe Sound, FLBuilt 1966 · S/N 15063760 N7161FRegistration Pending · Orange, CARegistration pendingBuilt 1966 · S/N 15063761 N7163FTomac Steven B · Yerington, NVBuilt 1966 · S/N 15063763 N7164FShear View Mulching LLC · Poplarville, MSBuilt 1966 · S/N 15063764 N7165FOlson Eric C · Portland, ORBuilt 1966 · S/N 15063765

Back to Cessna 150F