Registered aircraft · 16

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:87-18-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:87-18-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:87-18-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:87-18-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:87-18-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:87-18-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.

N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31 N164PAPhoenix Air Group Inc · Cartersville, GABuilt 1979 · S/N 257 N165PARca LLC · Wilmington, DEBuilt 1969 · S/N 775 N178BMissile Defense Agency (Mda) · Tulsa, OKBuilt 1973 · S/N 125 N17LKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 431 N183PASandy Wings LLC · Wilmington, DEBuilt 1984 · S/N 385 N184PABartowjets LLC · Wilmington, DEBuilt 1981 · S/N 318 N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489 N24YSRegistered aircraftBuilt 1968 · S/N 16 N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305 N550JFTs Aviation LLC · New York, NYBuilt 1985 · S/N 472 N710CFCalspan Corp · Niagara Falls, NYBuilt 1984 · S/N 448 N721CFCalspan Corp · Buffalo, NYBuilt 1984 · S/N 429 N74AMissile Defense Agency (Mda) · Tulsa, OKBuilt 1968 · S/N 36 N779LCTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1970 · S/N 88 N888WEPrime Aircraft & Aviation LLC · Edmond, OKS/N 394

Back to AD 87-18-07