Skip to content

Registered aircraft · 182

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

N1006ESpot-Air LLC · Burlington, TXBuilt 1977 · S/N 244-77 N1018EEichman Christopher J · Lake Oswego, ORBuilt 1977 · S/N 245-77 N101THHardy John R · Wasilla, AKBuilt 1978 · S/N 293-79 N1068EHafford Jay T · Stevenson, WAS/N 253-77 N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77 N1186EHowatt Air Inc · Langdon, NDBuilt 1977 · S/N 257-77 N1199EThibodeaux Brian A · Eagle River, AKS/N 254-77 N1217EJohnston Jason · Chugiak, AKS/N 255-77 N134RCScout Aviation LLC · Twin Falls, IDS/N 314-79 N141CHRegistered aircraftBuilt 1979 · S/N 324-79 N1470ZBig Tree LLC · Caldwell, IDS/N 189-76 N14WFSamberg Scott S · Gillette, WYBuilt 1976 · S/N 233-76 N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475 N178TTLockwood Kurt G · Fairbanks, AKBuilt 1978 · S/N 278-78 N181TMEichhorn Scott William · Searcy, ARS/N 114-74 N188RSVardaman Charles · Little Rock, ARBuilt 1979 · S/N 341-80 N19CKBuckmeier Arlan M · Fairbanks, AKBuilt 1978 · S/N 28078 N240SSStroup Robert L · New River, AZS/N 345-80 N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77 N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78 N2590ZWollaston Dean E · Hazel Green, WIBuilt 1977 · S/N 260-77 N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78 N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78 N2693ZCoen Brady · Wiley, COS/N 268-78 N2975QWorker Timothy M · Fairbanks, AKBuilt 1980 · S/N 346-80 N29762Davis Evan A · Fairbanks, AKS/N 352-80 N2981MPavey Rocky A · Fairbanks, AKBuilt 1980 · S/N 360-80 N333HTTiernan Barton M · Anchorage, AKBuilt 1979 · S/N 33380 N406JKKolstad Jon C · Glasgow, MTBuilt 1976 · S/N 231-76 N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76 N4132YMartin Beaux R · Calhoun, LAS/N 234-76 N4143YHasenfus Heidi J · Green Cove Springs, FLBuilt 1977 · S/N 236-77 N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877 N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77 N41819Crop Jet Aviation LLC · Gooding, IDBuilt 1974 · S/N 1-74 N4208YScout Towing Company · Omaha, NEBuilt 1977 · S/N 243-77 N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76 N474WBPhillips Kenneth R · Brackettville, TXBuilt 1974 · S/N 21-74 N488LGErnst Donald E · North Pole, AKBuilt 1975 · S/N 14175 N5029GArnold Michael P · Boise, IDBuilt 1978 · S/N 288-78 N5033DSigurdson Richard J · Olivia, MNBuilt 1978 · S/N 289-78 N5034NLittle Gregory L · Carnegie, OKBuilt 1979 · S/N 291-79 N5035QWilfer Dennis M · Fairbanks, AKBuilt 1979 · S/N 292-79 N50371Potter Michael J Jr · Fairbanks, AKBuilt 1978 · S/N 283-78 N50376Hayes Brad M · Grove, OKBuilt 1978 · S/N 282-78 N5042LBarker Bruce L · Liberal, MOBuilt 1979 · S/N 298-79 N5042NBates Hobart C · Dexter, MIS/N 299-79 N5042QHoover Mark B · Wasilla, AKBuilt 1979 · S/N 300-79 N5043LByker Aviation Inc · Hawarden, IABuilt 1979 · S/N 301-79 N5043SHrupsa David P · Felton, DES/N 303-79

Back to Bellanca 8GCBC