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.

N99RPMarden Management Company Inc · Reno, NVS/N R182-01517 N99SHRegistered aircraftBuilt 1964 · S/N 18255599 N99TMMagdabenja Holdings LLC · Corona, CABuilt 1977 · S/N 21061712 N99WFDukw Arkansas LLC · Hot Springs, ARBuilt 2017 · S/N 18283001 N99WGWilson Norman · Mount Pleasant, TXBuilt 1978 · S/N 210-62618 N99YED & E Recreation LLC · Dowling, MIBuilt 1975 · S/N 18264030 N99YFAspire Partners LLC · Evansville, INBuilt 1968 · S/N U2060940 N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608 N99ZHHolman Michael J · Anchorage, AKBuilt 1963 · S/N 18051291 N9BPLynn Marshall · Milford, MIBuilt 1973 · S/N 18262078 N9BTParlin Troy W · Wills Point, TXS/N 18255639 N9CGLindow Anthony D · Soldotna, AKBuilt 1960 · S/N 50732 N9EDTaylor Monty · Cornelius, NCBuilt 1972 · S/N 21059612 N9FVGeorgia Forestry Commission · Macon, GABuilt 1998 · S/N 18280106 N9GCCleland Michael J · Pleasanton, CABuilt 1963 · S/N 205-0253 N9HMRonay Thomas G Trustee · Nampa, IDBuilt 1980 · S/N 18053165 N9HQBacon Joseph M · Fenton, MIS/N 18051946 N9JPEcho Air Inc · Woodstock, GABuilt 1973 · S/N 210-59926 N9LGCalfee Ray I · Charleston, TNBuilt 1962 · S/N 18254559 N9MLBobcheeto LLC · Newark, DEBuilt 1978 · S/N R18200620 N9MTGaroutte Kirk Edward · Anchorage, AKBuilt 1949 · S/N 7394 N9NCulley Terry L · Lebanon, INBuilt 1978 · S/N 18266518 N9PCMeloche Michael S Trustee · Hamilton, MTBuilt 1949 · S/N 7437 N9PDPowell Distributing Co Inc · Portland, ORBuilt 1969 · S/N 18052062 N9RLKrug Heath · Colusa, CABuilt 1964 · S/N 18255986 N9RPMalmberg Wendell A · Snohomish, WABuilt 1973 · S/N 18262525 N9SWWilliamson Shane Trustee · Grants Pass, ORBuilt 1974 · S/N 18263118 N9TLGospel Ministries International Inc · Collegedale, TNBuilt 1973 · S/N 18262680 N9TRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 21059846 N9XJMontgomery Flying Club Inc · Montgomery, ALBuilt 1979 · S/N R18201014 N9XNRodman T Allin · Waco, TXS/N 21063616

Back to AD 84-10-01 R1