Skip to content

Registered aircraft · 487

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

N1013EFouts Chester L · Turner, MTBuilt 1977 · S/N 970-77 N1035EJobe Ronald G · Sedalia, MOBuilt 1977 · S/N 983-77 N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77 N1056EMorrow James V · Boise, IDBuilt 1977 · S/N 974-77 N1061ENeal Foster Trucking Inc · Woodland, CABuilt 1977 · S/N 975-77 N1072ESabbatino Robert F · New Milford, CTBuilt 1977 · S/N 976-77 N1074LPurpose Flight Inc · Wilmington, DES/N 97777 N1095EIndependent Dusting Service Inc · El Campo, TXBuilt 1977 · S/N 980-77 N10987Andreassen Ray E · Delta Junction, AKBuilt 1972 · S/N 330-72 N10989Rickert Randy M · Lehighton, PABuilt 1972 · S/N 334-72 N10990Speed And Angels LLC · Dover, DEBuilt 1971 · S/N 329-72 N1108EScissortail Aviation LLC · Enid, OKBuilt 1977 · S/N 984-77 N1116ESkyhawk Aviation LLC · Albuquerque, NMBuilt 1977 · S/N 981-77 N111HMSciara Flying Service LLC · Eudora, ARBuilt 1978 · S/N 1055-78 N1138EGemfire Ventures LLC · Saint Petersburg, FLBuilt 1977 · S/N 985-77 N113MEButler Robyn L · Vale, ORS/N 909-76 N1156EGooding Flying Club · Gooding, IDBuilt 1977 · S/N 986-77 N1163EKnik Flying Club LLC · Anchorage, AKS/N 987-77 N11645Tango Bravo Air LLC · Nederland, COBuilt 1972 · S/N 344-72 N11647Ronsman Harry · Talkeetna, AKBuilt 1972 · S/N 345-72 N11657Morgan Jacob R · Salem, INBuilt 1972 · S/N 347-72 N11668Cummings Arthur J · Delta Junction, AKS/N 349-72 N11673Clobes Warren J · Evansville, WIBuilt 1972 · S/N 356-72 N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72 N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77 N11GFCompton Robert · Groveland, CABuilt 1974 · S/N 668-74 N1206EStrassburg Wayne W · Galena, AKS/N 990-77 N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72 N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272 N128SMHafford Jay T · Stevenson, WAS/N 1162-79 N1369BFryt Michael J · Goldsboro, NCS/N 371-72 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N14JRAerial Reconnaissance Inc · Trent Woods, NCS/N 479-73 N169EZMallory Jessica Lynn · Anchorage, AKBuilt 1976 · S/N 927-76 N1705ZJohnston Daryl T · Euless, TXBuilt 1973 · S/N 474-73 N174RCCarsey Rick · Fowler, CAS/N 576-73 N1845MRaapana Patrick M · Fairbanks, AKS/N 522-73 N18XMUfer John M · Truman, MNBuilt 1973 · S/N 621-74 N200MBPurple Plane LLC · Granbury, TXBuilt 1972 · S/N 405-72 N20SBBrillaud Stephen A · Germantown, TNBuilt 1976 · S/N 917-76 N213AMNorton Cole R · Marion, IAS/N 559-73 N222WYLeach Ron B · Bliss, IDS/N 376-72 N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74 N24YHKoch Bernard L · Arriba, COBuilt 1974 · S/N 782-75 N2500ZGuldi James E · Port Orange, FLBuilt 1977 · S/N 991-77 N2514ZDarnoc LLC - Series 6 · Spicewood, TXBuilt 1977 · S/N 992-77 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N2546ZClark Brent R · Layton, UTBuilt 1977 · S/N 998-77 N2551ZHobson Simon · Eagle River, AKBuilt 1977 · S/N 999-77 N2562ZMortvedt Arthur D Trustee · Manley Hot Springs, AKS/N 1023-78

Back to Bellanca 7GCBC