Skip to content

Registered aircraft · 20,481

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N9946MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700588 N9946TKruger Matthew J · Pine Island, MNBuilt 1960 · S/N 18253046 N9946XBarber Edward G Jr · Anchorage, AKBuilt 1961 · S/N 185-0146 N9947BClarke Adam M · Lompoc, CAS/N 34347 N9947CLoftin Aviation Group LLC · Suwanee, GABuilt 1978 · S/N R18200489 N9947EAstle James H · St John, KSBuilt 1975 · S/N 18264007 N9948Barron Jon M · Perry, MOS/N 7815 N9948MGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 20700759 N9948TMoulton Robert J · Filer, IDBuilt 1960 · S/N 18253048 N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767 N9949NFox Heather J · Bettles Field, AKBuilt 1975 · S/N 18052604 N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312 N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470 N99501Bennett Gary R · Anchorage, AKBuilt 1971 · S/N 18260598 N9950NRegistration Pending · Petersburg, AKRegistration pending, pending cancellationS/N 18052605 N9950XHedlund Mark · Kasilof, AKBuilt 1961 · S/N 185-0150 N9951EBlue Skylane LLC · Sunriver, ORBuilt 1975 · S/N 18264011 N9951HFormula 182 LLC · Phoenix, AZBuilt 1981 · S/N 18268137 N9951NAckerman Dennis W · Anchorage, AKBuilt 1975 · S/N 18052606 N9951XBrown Rosalee Jo · Minnetrista, MNBuilt 1961 · S/N 185-0151 N9952MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1976 · S/N 207-00345 N9952RBlanchard Ken E · Lumberton, MSS/N U20606997 N9952ZMcdougall Enterprises LLC · Tualatin, ORBuilt 1983 · S/N U20606771 N9953ESutton Gregg S · Orono, MNBuilt 1975 · S/N 18264013 N9953HRegistered aircraftBuilt 1981 · S/N 18268139 N9953MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1980 · S/N 20700656 N9954BWest James R · Xenia, OHS/N 34354 N9954EChase Ronald L · Payson, AZBuilt 1975 · S/N 18264014 N9954HApplied Dimension LLC · Hinsdale, NYBuilt 1981 · S/N 18268140 N9954NWhitmer Lyle E · Fairbanks, AKBuilt 1975 · S/N 18052609 N9954TWoodford Douglas P · Colbert, WABuilt 1960 · S/N 18253054 N9955CBrenna Matt R · Austin, TXBuilt 1978 · S/N R18200491 N9955ESanchez Angel David · Houston, TXBuilt 1975 · S/N 18264015 N9955JMehling Robert C · Hardin, MTS/N T18803884T N9955TWheeler Aaron T · Columbia, TNBuilt 1960 · S/N 18253055 N9955XMurphy Niccolai A · Poway, CABuilt 1961 · S/N 185-0155 N9956EBankuti Steve A · Littlerock, WABuilt 1975 · S/N 18264016 N9956HOldtown Aviation LLC · Priest River, IDBuilt 1981 · S/N 18268141 N9956MRyan Air Inc · Anchorage, AKBuilt 1983 · S/N 20700763 N9957BToby Aviation LLC · Manassas, VABuilt 1957 · S/N 34357 N9957MArctic Aviation Leasing LLC · Anchorage, AKBuilt 1983 · S/N 20700764 N9957NGasper Air Spray Inc · Crookston, MNFirst renewal noticeBuilt 1975 · S/N 18052612 N9957RScg Leasing LLC · Owensboro, KYBuilt 1986 · S/N U20606999 N9957TDaniels Luke D · Palmer, AKBuilt 1960 · S/N 18253057 N9957XHutchison Robert T · Big Lake, AKBuilt 1961 · S/N 185-0157 N9958BSouthern Aircraft Leasing LLC · Montgomery, ALS/N 34358 N9958EAirtauk LLC · Montauk, NYBuilt 1975 · S/N 18264018 N9958HCity Of Albuquerque · Albuquerque, NMBuilt 1981 · S/N 18268143 N9958NShimpa Michael A · Maple Grove, MNBuilt 1975 · S/N 18052613 N9958TKonefal Arthur J · Fairbanks, AKBuilt 1960 · S/N 18253058

Back to AD 84-10-01 R1