Registered aircraft · 66

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

N580SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 30294 N6226HMagnum Aviation LLC · Goff, KSS/N 2046 N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171 N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239 N679HHillcrest Aircraft Co · Lewiston, IDBuilt 1974 · S/N 30164 N67FURotak LLC · Anchorage, AKBuilt 1967 · S/N 2064 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)N808MLCopter Lease LLC Trustee · Albuquerque, NMBuilt 1966 · S/N 2043 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 2016-22-07