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.

N7938FPanik Kevin R · Titusville, FLS/N 15064038 N7940FMile High Flight Club Inc · Miami, FLBuilt 1966 · S/N 15064040 N7941FLewis William J · Nashville, TNBuilt 1966 · S/N 15064041 N7943FRegistered aircraftBuilt 1966 · S/N 15064043 N7944FBrown R Ed · Vandalia, ILS/N 15064044 N7946FPaul Paulson A · Kipnuk, AKBuilt 1966 · S/N 15064046 N7952FKagey Ryan D · Seabrook, TXBuilt 1966 · S/N 15064052 N7954FVikingland Flying Club · Alexandria, MNS/N 15064054 N7955FN7955f LLC · Titusville, FLS/N 15064055 N7956FFios Flightline LLC · Tucson, AZBuilt 1966 · S/N 15064056 N7962FFlying Colors Airparts Inc · Leesburg, FLBuilt 1966 · S/N 15064062 N7968FFlyin Cowboys · Manning, NDBuilt 1966 · S/N 15064068 N7970FConnor Christopher Donnie · Chicago, ILBuilt 1966 · S/N 15064070 N7971FJanes Christopher D · Columbia, KYBuilt 1966 · S/N 15064071 N7974FMerriam Hugh M · San Leandro, CABuilt 1966 · S/N 15064074 N7979FAtkins Adam T · Fort Mill, SCBuilt 1966 · S/N 15064079 N7982FPlane Sane C1 LLC · Cary, NCS/N 15064082 N7983FKoons Brian D · Canton, OHBuilt 1966 · S/N 15064083 N7987FMillican Troy · New Ulm, TXBuilt 1966 · S/N 15064087 N7996FRounds Donald C DBA · Waller, TXS/N 15064096 N7998FBooth Donald V · Denison, TXBuilt 1966 · S/N 15064098 N7SQTangassi Sergio · Gilbert, AZBuilt 1966 · S/N 15063743 N8001FJohnston Joshua T · Aurora, MOS/N 15064101 N8003FNovember Fox LLC · Quilcene, WAS/N 15064103 N8004SRege Bill · Cloverdale, CAS/N 15061604 N8005SFletcher Michael A · Vancouver, WABuilt 1965 · S/N 15061605 N8006SBering Capital LLC · Anchorage, AKBuilt 1965 · S/N 15061606 N8007FSimms Peter W · Wellsville, NYFirst renewal noticeS/N 15064107 N8007SGolden Aerial Services LLC · Erie, PABuilt 1965 · S/N 15061607 N8009FRucinski Edward A · Climax, NCBuilt 1966 · S/N 15064109 N800HEFredericks Kenneth L · Halliday, NDBuilt 1965 · S/N 15061602 N8010FTorres Mora Jose Alberto · Modesto, CABuilt 1966 · S/N 15064110 N8012FHood William T · Columbia, SCBuilt 1966 · S/N 15064112 N8012SCollins Scott · Upland, CABuilt 1965 · S/N 15061612 N8013SRedmond Angela L · Austin, TXBuilt 1965 · S/N 15061613 N8014SMurray Bart · Pacifica, CAS/N 15061614 N8015FLewis L Dwight Jr · Lopez Island, WABuilt 1966 · S/N 15064115 N8017SHughes Todd R · Rocky Ford, COS/N 150-61617 N8019FLyman Kenneth R · Livermore Falls, MEBuilt 1966 · S/N 15064119 N8021SKoehn Mark W · Elkader, IAS/N 15061621 N8023SBalles Jeffrey J Sr · Hunker, PABuilt 1965 · S/N 15061623 N8024SOmlid Robert L · Watford City, NDBuilt 1965 · S/N 15061624 N8025FFurlong Kelly L · Athens, ALBuilt 1966 · S/N 15064125 N8025SBranch Timothy · Russellville, ARBuilt 1965 · S/N 15061625 N8026FCardoza Bren J · Port Hueneme, CABuilt 1966 · S/N 15064126 N8029SPapich William · Boston, NYBuilt 1965 · S/N 15061629 N8030SWatson William E · Glen Rose, TXBuilt 1965 · S/N 15061630 N8031FDevine Steven Anthony · Gilbert, AZS/N 15064131 N8034FDavis Matthew B · Silsbee, TXBuilt 1966 · S/N 15064134 N8035SLongstreth Seth Allen · Lancaster, OHBuilt 1965 · S/N 15061635

Back to Cessna 150F