Skip to content

AD 2008-10-10 R1

Registered aircraft · 783

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:2008-10-10-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:2008-10-10-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:2008-10-10-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:2008-10-10-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:2008-10-10-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:2008-10-10-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.

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 N935ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 30081 N935NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33231 N936ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29532 N936NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31176 N937ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30082 N937NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31178 N938ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 29533 N938NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33490 N939ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30083 N939NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33491 N940ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30598 N940NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33323 N941ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29534 N941NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33232 N942ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30084 N942NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33492 N943ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30599 N943NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31177 N944ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29535 N944NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31185 N945ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30085 N945NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33233 N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600 N946NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33234 N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536 N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190 N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086 N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189 N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537 N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192 N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115 N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087 N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328

Back to AD 2008-10-10 R1