Skip to content

Registered aircraft · 709

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-09-02-R2') 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-09-02-R2') 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-09-02-R2')
    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-09-02-R2')
  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-09-02-R2')
  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-09-02-R2')
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.

N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525 N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526 N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527 N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077 N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N931ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30079 N932ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29530 N933ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30080 N934ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29531 N935ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 30081 N936ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29532 N937ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30082 N938ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 29533 N939ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30083 N940ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30598 N941ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29534 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483 N942ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30084 N943ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30599 N943FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2518 N944ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29535 N945ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30085 N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600 N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536 N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086 N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537 N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089 N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540 N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828 N960ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29542 N961ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30092 N962ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30858 N963ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29543 N964ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30093 N965ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29544 N966ADBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1966 N966ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30094 N967ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29545

Back to AD 97-09-02 R2