Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N1179BSchuyler Paul · Morgan Hill, CABuilt 1947 · S/N 5806 N1179KGingerich Roger · Narvon, PABuilt 1946 · S/N 3906 N1180KFlying Luscombe LLC · Okeechobee, FLBuilt 1946 · S/N 3907 N1184BNelson Fred L III · Brandon, MSBuilt 1947 · S/N 5811 N1184KO'Brien A Scott · Santa Rosa Valley, CABuilt 1946 · S/N 3911 N1188BVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 5815 N1190KBlack Widow Aviation LLC · Sahuarita, AZBuilt 1946 · S/N 3917 N1191BMenees Terry J · Tempe, AZBuilt 1947 · S/N 5818 N1192BDunshee Anette M · La Luz, NMBuilt 1947 · S/N 5819 N1193BBlackburn Richard L · Pendleton, ORBuilt 1947 · S/N 5820 N1194BMclaughlin John P · North Royalton, OHBuilt 1947 · S/N 5821 N1196KStrader Wayne G · Ardmore, OKBuilt 1946 · S/N 3923 N1197KBrandt Judson C · Greenville, GABuilt 1946 · S/N 3924 N1198KKulle William T · Springfield, MABuilt 1946 · S/N 3925 N1200BSigns William E · Addison, TXS/N 5827 N1207KSmith Steven J · Chelsea, ALBuilt 1946 · S/N 3934 N1208KGrewell Ronald V · West Carrollton, OHS/N 3935 N1211BRegistered aircraftBuilt 1947 · S/N 5838 N1215AHoehne Michael G · Vienna, VAS/N 5842 N1217KMay Michael S · Axtell, NES/N 3944 N1219BBailey Steven D · Puyallup, WABuilt 1955 · S/N 5846 N1219KGiefer Brett T · Nicollet, MNBuilt 1946 · S/N 3946 N1221BJorgensen Lynn L · Panora, IABuilt 1947 · S/N 5848 N1225BLaforge William Scott · Sandwich, MAS/N 5852 N1228BErl Don L · Medford, WIBuilt 1947 · S/N 5855 N1230KReeves Roy Lee · Allen, TXBuilt 1952 · S/N 3957 N1231KMurphys Flying Service LLC · Quitman, GABuilt 1946 · S/N 3958 N1237BOmlid Robert L · Watford City, NDBuilt 1957 · S/N 5760 N1237KKush John J Jr · Oil City, PABuilt 1946 · S/N 3964 N1264KWarnock Edward R Trustee · Garden Valley, CABuilt 1946 · S/N 3991 N1268BLill Stephen P · Lafayette, LABuilt 1947 · S/N 5895 N1273BDorazio Rp · Winooski, VTS/N 5900 N1275KHarris Kenneth B · El Dorado, ARBuilt 1946 · S/N 4002 N1277BBennett Robert M · Felton, DEBuilt 1947 · S/N 5904 N1278KHanson Toby J · Webster, MNBuilt 1946 · S/N 4005 N1279BCrane Ryan S · Poplar Grove, ILBuilt 1947 · S/N 5906 N1279KPellenz Edward J · Brandon, FLBuilt 1946 · S/N 4006 N127DBPrice Gregory L · Kyle, TXBuilt 1947 · S/N 5874 N1280BTailwheel Aviators Llp · Kokomo, INBuilt 1947 · S/N 5907 N1282BSchrage John R · Urbandale, IABuilt 1947 · S/N 5909 N1286BIngraham Jim E · Woodland, CAS/N 5913 N1291BKegin Kevin M · Salem, ILBuilt 1947 · S/N 5918 N1293BHamilton Terry D · Adams, MNBuilt 1947 · S/N 5920 N1294MPosey Brothers Inc · Pipersville, PABuilt 1946 · S/N 4021 N1297KMills Robert D · Newport, MIBuilt 1946 · S/N 4024 N1303KMiller James A · Granada Hills, CABuilt 1946 · S/N 4030 N1304KMurphy Glen T · Campbell, TXBuilt 1946 · S/N 4031 N1313KWestrum Durl T · Norwalk, IABuilt 1946 · S/N 4040 N1315KBrumby William R · Dunnellon, FLS/N 4042 N1318KPratt James M III · Hoffman Estates, ILBuilt 1947 · S/N 4045

Back to Luscombe 8A