Registered aircraft · 18

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:95-01-06-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:95-01-06-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:95-01-06-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:95-01-06-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:95-01-06-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:95-01-06-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.

N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N24089Ploutz Lloyd · Modesto, CAS/N 20455 N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904 N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606 N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917 N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747 N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707 N360WANorthern Air Cargo LLC · Anchorage, AKBuilt 1987 · S/N 23553 N370BCBcm Majestic Corp · Dallas, TXBuilt 1986 · S/N 23468 N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N465TWSierra American Corp · Wilmington, DES/N 23465 N467TWSierra American Corp · Wilmington, DES/N 23466 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N73HKWilmington Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 21957 N740ASAlaska Aviation Museum · Anchorage, AKBuilt 1981 · S/N 22578 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538

Back to AD 95-01-06 R1