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.

N73467Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700594 N7346SWood Donald · Spring Branch, TXBuilt 1976 · S/N 18265137 N7347NAv8 LLC · Boise, IDS/N U20603624 N7347QMitchell David L · Imperial, TXBuilt 1972 · S/N 18260987 N7347SRegistered aircraftAssigned, pending cancellationS/N 18265138 N7348XShielded Holdings LLC - Series Av 11 · Katy, TXBuilt 1977 · S/N R18200083 N7349CMcbride Patrick J · Anchorage, AKBuilt 1977 · S/N U20603888 N734CWilliams Jimmy D · Goodwell, OKBuilt 1967 · S/N 18258134 N734CXMount Crillon LLC · Juneau, AKBuilt 1978 · S/N U20604823 N734EJLavery Sam · Morgantown, WVBuilt 1978 · S/N U20604828 N734GWRwr Air Inc · Tok, AKBuilt 1978 · S/N U20604832 N734HXWaters Aero- Marine Inc DBA · South Thomaston, MES/N U20604837 N734JCRegistered aircraftBuilt 1977 · S/N 21062107 N734PPKelley Jon B · Anchorage, AKBuilt 1979 · S/N U20604855 N734SGRydalch Carl D · Saint Anthony, IDBuilt 1965 · S/N 18256270 N734TMCorporate Air Service Inc · North Salt Lake, UTBuilt 1979 · S/N U20604870 N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883 N734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1979 · S/N U20604886 N73503Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700599 N7350EMuszynski Jerry · Huntington Beach, CABuilt 1959 · S/N 57050 N7350RScenic Concepts LLC · La Crosse, WIBuilt 1978 · S/N R18200646 N7350SObrien Timothy K · Huntington Beach, CABuilt 1976 · S/N 18265141 N7351UBlue Waves Holding One LLC · Miami, FLBuilt 1977 · S/N 20700415 N7351YDunne Brian T · Wichita, KSBuilt 1977 · S/N R18200121 N7352ELandgraf James P Trustee · Camas, WABuilt 1960 · S/N 57052 N7353EFitzpatrick Michael H · Anchorage, AKBuilt 1959 · S/N 57053 N7354HSale Reported · Madison, ALSale reportedBuilt 1981 · S/N 18267909 N7354NGilleland Earl C · Oakwood, GABuilt 1974 · S/N 18263138 N7354QRegistration Pending · Austin, MNRegistration pendingBuilt 1972 · S/N 18260994 N7354SHobbs Meeks Victoria · Miami, FLBuilt 1976 · S/N 18265145 N7356EJouppi Kenneth J · Ward Cove, AKBuilt 1959 · S/N 57056 N7356SSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 18265147 N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945 N7358NHnat Peter Paul · Foresthill, CABuilt 1974 · S/N 18263142 N7358SHittle Thomas W · East Haven, CTBuilt 1976 · S/N 18265149 N7359CAhlem Charles D · Hilmar, CABuilt 1977 · S/N U20603897 N7359EHomes Richard Bryant · Charleston, SCBuilt 1984 · S/N 18268380 N7359TKort Thomas J · Lake Tomahawk, WIBuilt 1977 · S/N R18200031 N735AAKnight Kevin D · Hereford, TXBuilt 1976 · S/N 18265260 N735ABPapalote Ranches LLC · Missoula, MTBuilt 1976 · S/N 18265261 N735ACKempton Larry G Jr · Grand Junction, COBuilt 1976 · S/N 18265262 N735ADMassery Dean P · Lake Milton, OHBuilt 1976 · S/N 18265263 N735AFJanssen Rod · Beaufort, SCBuilt 1976 · S/N 18265265 N735AHMark R Cooper Aviation LLC · Fort Wayne, INBuilt 1976 · S/N 18265267 N735AKKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265269 N735ALGml Flight Service LLC · Las Cruces, NMBuilt 1976 · S/N 18265270 N735AMJohnson Mark S · Bremerton, WABuilt 1976 · S/N 18265271 N735ANAmerican Eagle Flying Club · New Hudson, MIBuilt 1976 · S/N 18265272 N735APJay Bee Aviation LLC · Okeechobee, FLBuilt 1976 · S/N 18265273 N735ARHaller Michael J · Clayton, NCBuilt 1976 · S/N 18265275

Back to AD 84-10-01 R1