Registered aircraft · 164

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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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.

N893PMPorter Flying Service · Durham, CABuilt 1962 · S/N 62-1923 N911RQSimmons Robert J · Hayward, CAS/N 66-16298 N91320Avag Inc · Richvale, CABuilt 1962 · S/N 62-1887 N92530S W Florida Aviation International Inc · Arcadia, FLBuilt 1969 · S/N 11445 N94NWNorthwest Helicopters I Inc · Olympia, WABuilt 1996 · S/N 66-01101 N959BHBering Air Inc · Nome, AKBuilt 1964 · S/N 6413808 N96ECAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1968 · S/N 68-16596 N970MBSky High Leasing LLC · Montrose, COBuilt 2021 · S/N A94-0057 N97NWNorthwest Helicopters LLC · Olympia, WABuilt 1965 · S/N 65-09823 N98NWPope James D · Clarkston, WABuilt 1964 · S/N 64-13822 N99021Magnum Aviation LLC · Goff, KSBuilt 1965 · S/N 64-13949 N99478Vf99478 LLC · Wilmington, DEBuilt 1963 · S/N 63-8636 N99675Alaska Remote Outfitters LLC · Kenai, AKBuilt 1963 · S/N 624601 N99WLCorpat Inc · Missoula, MTBuilt 1970 · S/N 30086

Back to AD 97-21-07 R1