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.

N3744FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30837 N37456United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37205 N3745BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 32373 N37462United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37207 N37464United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41745 N37465United Airlines Inc · Chicago, ILBuilt 2013 · S/N 36599 N37466United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31644 N37468United Airlines Inc · Chicago, ILBuilt 2013 · S/N 32836 N3746HDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30488 N37470United Airlines Inc · Chicago, ILBuilt 2013 · S/N 37099 N37471United Airlines Inc · Chicago, ILBuilt 2013 · S/N 37102 N37474United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31648 N3747DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 32374 N3748YDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30489 N3749DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30490 N374DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29622 N374DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8810 N374NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1646 N374UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65909 N3750DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 32375 N3751BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30491 N3752Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30492 N3753Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 32626 N3754ADelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29626 N3755DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29627 N3756Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30493 N3757DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30813 N3758YDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30814 N3759Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30815 N375DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29623 N375DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8812 N375NCDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1789 N375UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66810 N3760CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30816 N3761RDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29628 N3762YDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30817 N3763DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29629 N3764DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30818 N3765Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30819 N3766Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30820 N3767Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30821 N3768Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29630 N3769LDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 30822 N376DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29624 N376DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8858 N376NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1812 N376UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66811 N37700Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29631 N3771KDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29632 N3772HDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30823

Back to AD 2009-21-10 R1