Skip to content

AD 2005-24-03 R1

Registered aircraft · 772

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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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.

N909NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31159 N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512 N910NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 31160 N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513 N912NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33319 N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514 N913NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29571 N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515 N914NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31161 N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516 N915NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33227 N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517 N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163 N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518 N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572 N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519 N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228 N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520 N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573 N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165 N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522 N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229 N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523 N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574 N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524 N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167 N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525 N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486 N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526 N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169 N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527 N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321 N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077 N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171 N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528 N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N930NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33487 N931ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30079 N931NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33230 N932ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29530 N932NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33488 N933ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30080 N933NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31173 N934ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29531 N934NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33489

Back to AD 2005-24-03 R1