Skip to content

AD 2009-21-10 R1

Registered aircraft · 4,274

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:2009-21-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:2009-21-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:2009-21-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:2009-21-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:2009-21-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:2009-21-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.

N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172 N929AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7525 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N929DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53459 N929DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63538 N929JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6031 N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322 N929UPBoeing Co · Renton, WAS/N 70804 N92BSS&E Aviation LLC · Birmingham, MIBuilt 2003 · S/N 1502 N93003Umb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5704 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N930AUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7539 N930CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47363 N930DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53458 N930DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63539 N930NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33487 N930TBBoeing Co · Renton, WABuilt 1995 · S/N 53388 N930UPBoeing Co · Renton, WAS/N 70805 N931AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7541 N931ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30079 N931NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33230 N931TBBoeing Company · Renton, WABuilt 1998 · S/N 53532 N931UPBoeing Co · Renton, WAS/N 70806 N932AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7419 N932ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29530 N932CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1970 · S/N 47465 N932NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33488 N932UPBoeing Co · Renton, WAS/N 70807 N933AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7564 N933ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30080 N933NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31173 N933UPBoeing Co · Renton, WAS/N 70808 N934AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7500 N934ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29531 N934JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6130 N934NANational Aeronautics And Space Administration · Houston, TXS/N 47428 N934NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33489 N935ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 30081 N935CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47413 N935JBJet Blue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6185 N935NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33231 N935RWelcome Grove LLC · West Sacramento, CABuilt 2000 · S/N 1405 N936AM936am LLC · Mount Pleasant, SCBuilt 2002 · S/N 1488 N936ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29532 N936CAAc Spe 8 LLC · Orlando, FLBuilt 1991 · S/N 25308 N936NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31176 N937ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30082 N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245 N937NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31178 N938ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 29533

Back to AD 2009-21-10 R1