Skip to content

Registered aircraft · 347

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

N1008EEdwards Gregory S · Guthrie, OKS/N 1202-77 N1011TPedersen Michael · Bakersfield, CABuilt 1972 · S/N 863-72 N1014EMeade Lance M · Stinson Beach, CABuilt 1977 · S/N 1203-77 N1021EYoung David S · San Jose, CABuilt 1977 · S/N 1204-77 N1034ENexga Aircraft Inc · Greensboro, NCBuilt 1977 · S/N 1205-77 N1042EPerez Alexander · Palmer, AKBuilt 1977 · S/N 1207-77 N1055ERed Aero LLC · Scottsdale, AZBuilt 1977 · S/N 1208-77 N1073EMurphys Flying Service LLC · Thomasville, GABuilt 1977 · S/N 1209-77 N1075EWeiland Adam W · Evergreen, COBuilt 1977 · S/N 1214-77 N1090ECrouse John A · Sterling, AKBuilt 1977 · S/N 1210-77 N1102ELee Robert J Trustee · Denver, NCBuilt 1977 · S/N 1211-77 N1103EPhantom Flyer LLC · Yelm, WABuilt 1977 · S/N 1212-77 N1114EGetz Darrel P · Colfax, WABuilt 1977 · S/N 1213-77 N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77 N11642Alexander Andrew B · Anchorage, AKBuilt 1972 · S/N 836-72 N1164DStreng Martin K · Carson City, NVBuilt 1972 · S/N 837-72 N11650Dupuis Charles Jr · Breaux Bridge, LABuilt 1972 · S/N 839-72 N1165ETruman Sparks Aviation LLC · Wink, TXBuilt 1977 · S/N 1216-77 N11663Parisi Keith P · Wallkill, NYBuilt 1972 · S/N 842-72 N11664Mosher Jacob D · Nevada, MOBuilt 1972 · S/N 843-72 N11667Winiarski Kenneth J · Forest Twp, MEBuilt 1972 · S/N 845-72 N11670Michaud Paul K · Forest Lake, MNBuilt 1972 · S/N 846-72 N11672Mooney Services LLC · Greenbush, MNS/N 848-72 N11675Nilles Paul · Athens, OHBuilt 1972 · S/N 850-72 N11683Osborne Barry G · Brainerd, MNBuilt 1972 · S/N 852-72 N11693Miller Robert A · Auburn, CAS/N 853-72 N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72 N11704Jackman William L · Newman Lake, WAS/N 857-72 N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72 N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72 N1174EInman James Dylan · Parsons, TNS/N 1228-78 N1179EPlane Air LLC · Paducah, KYBuilt 1977 · S/N 1220-77 N1184EHutchins Chad M · Colorado Springs, COBuilt 1977 · S/N 1217-77 N11854Wildenberg Craig E · Menomonie, WIBuilt 1972 · S/N 825-72 N11861Haga Kim E · Karlsruhe, NDS/N 829-72 N13RHChrist Graham Charles · Mandeville, LABuilt 1973 · S/N 973-73 N166RSThiessen David · Brownsville, TXBuilt 1972 · S/N 876-72 N170MLLacey David G · Locust Grove, GABuilt 1974 · S/N 1074-75 N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74 N1984ZLynx Aviation Inc · King Salmon, AKBuilt 1973 · S/N 912-73 N2501ZSmith Glenn G Jr · Ardmore, OKBuilt 1977 · S/N 1219-77 N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78 N2536ZLemanski Thomas A · Port Townsend, WAS/N 1250-78 N2575ZDavis Mary G · Friendswood, TXBuilt 1977 · S/N 1221-77 N2650ZFrederick James H · Springfield, OHBuilt 1977 · S/N 1223-77 N2666ZBig Falls Flying Club Inc · Intl Falls, MNS/N 1224-78 N2683ZAmmlim LLC · Vacaville, CABuilt 1978 · S/N 1227-78 N2696ZAdriatic Holdings LLC · Cheyenne, WYBuilt 1978 · S/N 1230-78 N26PKLauda Thomas J · Des Moines, IABuilt 1974 · S/N 1041-74 N2725ZGeorge Ladelle L · Ashley, NDS/N 1231-78

Back to Bellanca 7ECA