Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N999NFCoast Flight Training And Management Inc · San Diego, CABuilt 2002 · S/N 4496138 N999NTHolbrook Joel · Delta Junction, AKS/N 22-5225 N999TXDel Mar College · Corpus Christi, TXBuilt 1960 · S/N 25392 N999VLHeidt Brian F · Owosso, MIBuilt 1958 · S/N 22-6451 N99ARTiffin Aire Inc · Tiffin, OHBuilt 1969 · S/N 30-1881 N99EGGrant Gerald F Trustee · Maplewood, MNBuilt 1973 · S/N 31P-7400180 N99FBFreedman Doreen Trustee · Liberty Hill, TXBuilt 1965 · S/N 24-4338 N99FPShort Jon P · Cullman, ALFirst renewal noticeBuilt 1978 · S/N 27-7854119 N99JLMattson Eric J · Saint Paul, MNBuilt 1959 · S/N 24-1579 N99LBVolz Laura M Trustee · Williamsville, NYBuilt 1960 · S/N 24-2265 N99MDJinkins Richard D · Rewey, WIBuilt 1955 · S/N 23-325 N99MTGardner Donald G · Granbury, TXBuilt 1966 · S/N 24-4526 N9APWellsville Flying Service Inc · Wellsville, NYS/N 27-7305129 N9DCColeman Jet Solutions LLC · Highland Park, ILBuilt 1982 · S/N 44-8107065 N9DGRichmond Stephen C · Luthersville, GAS/N 30-1585 N9KDGerada Matthew T · Bossier City, LABuilt 1963 · S/N 24-3480 N9KPEmmons Russell S · Waterbury, CTS/N 24-3150 N9NYDanner Jason · Burleson, TXBuilt 1965 · S/N 30-739 N9PEN9pe LLC · Locust Grove, GABuilt 1972 · S/N 39-143 N9XTDawdle LLC · Casanova, VABuilt 1969 · S/N 24-4857

Back to AD 85-02-05 R1