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.

N371NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2095 N371NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1535 N371UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65791 N37252United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30583 N37253United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30584 N37255United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30610 N37263United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31583 N37267United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31586 N37273United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31591 N37274United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31592 N37277United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31595 N37281United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31599 N37287United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31636 N37290United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31601 N37293Bank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 33453 N37298United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34004 N372CMAirborne Maintenance And Engineering Serives Inc · Wilmington, OHBuilt 1992 · S/N 25575 N372DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29620 N372DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8809 N372NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1633 N372UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65908 N3730BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30538 N3731TDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30775 N3732JDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30380 N3733ZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30539 N3734BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30776 N3735DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30381 N3736CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30540 N3737CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30799 N3738BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30382 N3739PDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30541 N373CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24929 N373DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29621 N373DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8734 N373JXJetonex LLC · Sunny Isles Beach, FLS/N 33735 N373NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1641 N373UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 66809 N37408United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30125 N37409United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30126 N3740CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30800 N37413United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31664 N37419United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31666 N3741SDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30487 N37420United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33457 N37422United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31620 N37427United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37097 N3742CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30835 N37434United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33528 N37437United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33532 N3743HDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30836

Back to AD 2009-21-10 R1