Registered aircraft · 68

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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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.

N8200RUS Special Operations Command · Tampa, FLBuilt 1996 · S/N 425 N8300GUS Special Operations Command · Tampa, FLBuilt 1991 · S/N 298 N837EXBank Of Utah Trustee · Salt Lake City, UTS/N 217 N839EXBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 226 N884EATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 387 N888XKDodson International Parts Inc · Rantoul, KSS/N 264 N891EATvpx Ars Inc Trustee · North Salt Lake, UTS/N 335 N965HABank Of Utah Trustee · Salt Lake City, UTS/N 509 N984HANorthrop Grumman Systems Corp · El Segundo, CABuilt 1994 · S/N 377 N985HAWells Fargo Trust Co Na Trustee · Columbia, MDS/N 479 N986HA645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1996 · S/N 421 N990AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1988 · S/N 099 N990BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 265 N991BHBig Horn Airways Inc · Sheridan, WYBuilt 1992 · S/N 324 N991HA645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1996 · S/N 431 N992BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 258 N993BHBighorn Airways Inc · Sheridan, WYBuilt 1998 · S/N 524 N997MG645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1997 · S/N 456

Back to AD 2004-03-15 R1