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.

N8000YConklin Matthew J · Boise, IDBuilt 1973 · S/N 18052391 N8001ZGfi Investments LLC · Gillette, WYBuilt 1965 · S/N U206-0401 N8002KTrepanier Dennis A · Santa Fe Springs, CABuilt 1969 · S/N 18259922 N8002ZNash Richard · Missoula, MTBuilt 1965 · S/N U206-0402 N8005JWelch Louis · Granbury, TXS/N 180-51037 N8005QMaslen Holbrook · Reno, NVBuilt 1961 · S/N 180-50995 N8006ZMathews Vincent W · Bryan, TXBuilt 1965 · S/N U206-0406 N800DFFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700621 N800FMartin Tyler · Waco, TXBuilt 1964 · S/N 205-0520 N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792 N800HPSanders George W Jr · Cloverdale, INFirst renewal noticeBuilt 1979 · S/N 18266903 N800JKWingjet Aviation LLC · Howard City, MIBuilt 1975 · S/N 18263593 N800JWImperial Valley Flight Training LLC · Calexico, CABuilt 1973 · S/N 18262541 N800LC54 Aero LLC · Spade, TXBuilt 1968 · S/N 18258879 N800MLNaples LLC · Mound City, MOBuilt 1966 · S/N 18257132 N800NLNewhalen Lodge Inc · Anchorage, AKBuilt 1979 · S/N U20604860 N800PReisch Travis S · Miami, OKBuilt 1983 · S/N 18268305 N800TGAftg Aviation LLC · Hopkins, MIBuilt 1978 · S/N R18200683 N800TXTexan LLC · Bloomington, INBuilt 1999 · S/N 18280526 N800WEOptic Air LLC · Maurice, IABuilt 1979 · S/N 18267408 N8010ZRosander Mining Co Inc · Mc Grath, AKBuilt 1965 · S/N U206-0410 N8011ZJackson Jet Center · Boise, IDS/N U206-0411 N8015ZKennedy Kerry D · Anchorage, AKBuilt 1965 · S/N U206-0415 N8017VThrush Hills LLC · Volga, SDBuilt 1967 · S/N 188-0267 N8019ZGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1965 · S/N U206-0419 N801ALWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280767 N801TCSturgeon N C · Midland, TXBuilt 2000 · S/N 20608103 N8022XAzzalin Giorgio · Jacksonville, FLBuilt 1953 · S/N 30637 N8027VWalton Philip G DBA · Mankato, KSBuilt 1967 · S/N 188-0277 N802CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283125 N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780 N802UMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700067 N8031QDonihoo Phillip D · Oklahoma City, OKBuilt 1974 · S/N 18262872 N803MWMowotech Inc · Boca Raton, FLBuilt 1979 · S/N 18267106 N8042VLakeview Aviation Inc · Sanborn, NDBuilt 1967 · S/N 188-0292 N8045Mcclure Richard A · Edna, TXS/N 18262046 N8045VGreater Houston Soaring Assoc · Needville, TXBuilt 1967 · S/N 188-0295 N8046VSt Bernard Parish Police Jury · Chalmette, LABuilt 1967 · S/N 188-0296 N8046ZBest Auto Sales LLC · Plummer, IDS/N U206-0446 N8047ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268385 N8047ZBooth James L · Bozeman, MTS/N 180-52312 N8048MWilson Curtis E · Townsend, GABuilt 1976 · S/N 18264532 N8048ZWalker John A · Kotzebue, AKS/N U206-0448 N804CAAshley Nostalgia · Midlothian, TXBuilt 1974 · S/N 18262942 N804PMSmp Outdoors Inc · Joseph, ORBuilt 1962 · S/N 18254108 N8050JParamus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281633 N8051BBryant James T Jr · Pryor, OKBuilt 1980 · S/N R18201574 N8051QLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1967 · S/N 18258064 N8051ZN8051z LLC · Anchorage, AKBuilt 1965 · S/N U206-0451 N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031

Back to AD 84-10-01 R1