Skip to content

AD 2020-25-03 R1

Registered aircraft · 2,040

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:2020-25-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:2020-25-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:2020-25-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:2020-25-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:2020-25-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:2020-25-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.

N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399 N346DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8227 N346FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8642 N346NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1796 N347DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8250 N347FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8811 N347NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1800 N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408 N348DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8258 N348FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8954 N348NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1810 N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410 N349DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8233 N349FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8766 N349NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1815 N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417 N350DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8207 N350FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8857 N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418 N351DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8251 N351FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8913 N351NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1820 N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766 N352DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8283 N352FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8976 N352NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1824 N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778 N353ASAersale Inc · Coral Gables, FLS/N 553 N353DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8322 N353FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8977 N353NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1828 N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786 N354DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8332 N354FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9026 N354NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1833 N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801 N355DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8359 N355FLBank Of Utah Trustee · Salt Lake City, UTS/N 2553 N355NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1839 N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807 N356DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8279 N356FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9065 N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818 N357DCAwas 3896 Trust · Wilmington, DES/N 3896 N357DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8339 N357NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1875 N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830 N358DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8316 N358FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9068 N358NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1897

Back to AD 2020-25-03 R1