Registered aircraft · 165

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

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 N988ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4251 N989ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4259 N990ACBank Of Utah Trustee · Salt Lake City, UTS/N 4216 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 N993ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4257 N993BHBighorn Airways Inc · Sheridan, WYBuilt 1998 · S/N 524 N997MG645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1997 · S/N 456 N998ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 4229

Back to AD 2002-06-06