Skip to content

Registered aircraft · 118

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

N1017EButtanda Denise · Winchester, VABuilt 1977 · S/N 342-77 N1048CPalmer Gretchen · Knoxville, TNBuilt 1976 · S/N 1153-76 N1048EPaul John R · Boise, IDBuilt 1977 · S/N 343-77 N11658Lorenz William D · Benson, MNBuilt 1972 · S/N 234-72 N11676Stone Air LLC · Carrollton, GABuilt 1972 · S/N 236-72 N11XXOconnell John · Custer, SDS/N 245-72 N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79 N2515ZMarker Richard A · Healdsburg, CABuilt 1977 · S/N 347-77 N2578ZMcclaskey Leslie Paul · New Albany, OHBuilt 1977 · S/N 348-77 N257DFHawkins Ian N · Kingwood, TXS/N 117 N2665ZRegistered aircraftBuilt 1978 · S/N 351-78 N2716ZWilson Miles · Mcminnville, TNBuilt 1978 · S/N 354-78 N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78 N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72 N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78 N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78 N2973ZLandrum Erik G · Austin, TXBuilt 1978 · S/N 359-78 N29788Lund Kevin J · Williamson, GABuilt 1980 · S/N 396-80 N298JBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 350-78 N31252Buchholz Claus W · Haslett, MIBuilt 1972 · S/N 249-72 N36008Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 268-73 N36028Armstrong Robert Reno · Lakin, KSS/N 264-73 N36251Gourley Eric G · Eastsound, WABuilt 1973 · S/N 274-73 N36267Ashcraft Keirsten · Longview, TXS/N 269-73 N36335Simmons Darren · Diamondhead, MSBuilt 1973 · S/N 271-73 N36350Hennager Eric D · Langdon, NDBuilt 1973 · S/N 272-73 N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73 N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73 N36768Miller Thomas O · Ingalls, KSBuilt 1973 · S/N 277-73 N4122YPetter David · Stuttgart, ARBuilt 1976 · S/N 333-76 N417SPTonys Aerial Service Inc · Great Bend, KSBuilt 1980 · S/N 1350-80 N41804Beulen Brian V · Mesa, AZBuilt 1973 · S/N 279-73 N41822Kitchen Thomas M · Indiana, PABuilt 1973 · S/N 280-74 N4213YFandrich Edward I · Payson, AZS/N 341-77 N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77 N466DSDrummond Michael S · Lewisville, NCBuilt 1978 · S/N 352-78 N476FMShumaker James B · Salinas, CABuilt 1978 · S/N 355-78 N5025DCal-Aerofab Flight Academy Inc · Chino, CABuilt 1978 · S/N 366-78 N5029ETimmins Christian · Covington, LABuilt 1978 · S/N 367-78 N5030TRegier Steven M · Fairview, OKBuilt 1978 · S/N 371-79 N5032J88 Charlies Inc · Palmyra, WIBuilt 1978 · S/N 372-79 N5033KRichard Robin G · New Franken, WIBuilt 1978 · S/N 369-78 N5034GDyson James R · Hilltop Lakes, TXBuilt 1978 · S/N 373-79 N5038AWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 376-79 N5038GStarros John P · Los Angeles, CABuilt 1979 · S/N 377-79 N5042DCollins Wanda · Madisonville, TXS/N 378-79 N50447Petrakis Brendan · Chester, NYBuilt 1979 · S/N 379-79 N5052YCall Tracy J · Carmel Valley, CABuilt 1979 · S/N 392-80 N5057PGolden John Daniel · Jay, FLBuilt 1979 · S/N 385-79 N5059KLucia Keith G · Pleasant Hill, CABuilt 1979 · S/N 387-79

Back to Bellanca 7GCAA