Registered aircraft · 60

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:92-27-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-27-21') 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:92-27-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-27-21')
  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:92-27-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-27-21')
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.

N679HHillcrest Aircraft Co · Lewiston, IDBuilt 1974 · S/N 30164 N689HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N 30289 N68ECCopter Lease LLC Trustee · Albuquerque, NMBuilt 1968 · S/N 30008 N750DMTradehawk International LLC · Ramona, CAS/N 66-16114 N775BBCopter Lease LLC Trustee · Albuquerque, NMBuilt 1977 · S/N 30252 N8056TAdvanced Aviation Technology Enterprises Inc · Arcadia, FLFirst renewal noticeS/N 30501(SW)N87LHHill Lawrence E · Marion, MTBuilt 1971 · S/N 30087 N90057Helibase Inc · Cape TownS/N 30500(SW)N933CHCoastal Helicopters LLC · La Verne, CABuilt 1969 · S/N 30062 N99WLCorpat Inc · Missoula, MTBuilt 1970 · S/N 30086

Back to AD 92-27-21