Skip to content

Registered aircraft · 44

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

N10982Burris Kye A · Gillett, ARBuilt 1972 · S/N 41-72 N10983Blakesley Eric R · Canandaigua, NYBuilt 1971 · S/N 42-72 N10985Lozier Kurt T · Albany, NYS/N 45-72 N12205Wilson Seth J · Glennallen, AKBuilt 1972 · S/N 48-72 N138MBHightower Jerry C · Boyd, TXS/N 56-72 N160CMOhler Brian M · Prosser, WABuilt 1971 · S/N 21-71 N31260Vix Aircraft Services LLC · Batesville, ARBuilt 1972 · S/N 67-72 N31270Kunkle James K · Santa Ynez, CABuilt 1972 · S/N 68-72 N31290Huntting Preston I · Camp Verde, AZBuilt 1972 · S/N 69-72 N62964Phelps Larry D · Vinton, IABuilt 1972 · S/N 52-72 N62965Mckenna David M · Newell, IAS/N 53-72 N62966Walker Richard E · Quanah, TXS/N 57-72 N62976Shales Rene J · Hampshire, ILBuilt 1972 · S/N 49-72 N68507Gall Peter D · Morgantown, WVS/N 55-72 N68516Brothers Aviation LLC · Black Rock, ARBuilt 1972 · S/N 54-72 N68529Jcads Inc · Tampa, FLBuilt 1972 · S/N 59-72 N68538Maneely Roy H · Wadsworth, OHBuilt 1972 · S/N 60-72 N8861Farabaugh Nano F · Elkhart, INBuilt 1973 · S/N 71-73 N88EVCarrier Timothy E · Waynesville, OHBuilt 1972 · S/N 64-72 N90979Keyes Roger S · Las Vegas, NVBuilt 1973 · S/N 70-73 N9133LThompson Clark J · Rosharon, TXBuilt 1971 · S/N 36-72 N9135LStudie Billy D · Wasilla, AKS/N 3-71 N9136LWelch Thomas R · Rimrock, AZBuilt 1971 · S/N 4-71 N9139LHurley William J III · Abingdon, ILBuilt 1971 · S/N 8-71 N9142LBrown Michael E Jr · Timmonsville, SCBuilt 1971 · S/N 11-71 N9147LNewton Justin T · Knox City, MOBuilt 1971 · S/N 13-71 N9150LKing Jessie M · Spring Valley, MNBuilt 1971 · S/N 12-71 N9154LKost Steven F · Fort Pierre, SDS/N 22-71 N9155LBelisle Barry A · Lancaster, TXBuilt 1971 · S/N 16-71 N9156LLerner Michael M · Tehachapi, CABuilt 1971 · S/N 17-71 N9161LBredlow Farming Co Inc · England, ARBuilt 1971 · S/N 23-71 N9162LBranum Seth L · Jonesboro, ARBuilt 1971 · S/N 24-72 N9163LLewallen William J · Eloy, AZBuilt 1971 · S/N 25-71 N9164LHodges Robert J · Savannah, GABuilt 1971 · S/N 26-71 N9165LJajade Farms Inc · Birmingham, MOBuilt 1971 · S/N 27-71 N9174LHunt Daniel R · Hayward, CABuilt 1972 · S/N 31-72 N9175LNeuroth Kurt V · Saint Charles, MOBuilt 1971 · S/N 32-72 N9176LMunoz Eduardo J · Acworth, GABuilt 1971 · S/N 35-72 N9177KBishop David · San Marcos, CAS/N 37-72 N9180LPoynter Everett B · Somerset, KYS/N 38-72 N9181LBrown Samuel L · Flatonia, TXBuilt 1971 · S/N 39-72 N9189LParker Jeffrey D · Chelsea, ALS/N 33-72 N9190LWilliamson Will R III · Florence, SCS/N 44-72 N9199LO Neill Mark B · Pinckney, MIS/N 34-72

Back to Bellanca 7ACA