Skip to content

AD 2020-25-03 R1

Registered aircraft · 2,037

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.

N528DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11248 N528VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7051 N529DTDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11277 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 N529VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7102 N530DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11245 N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153 N530VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7553 N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931 N531DADelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11329 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N531VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7626 N532DNDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11279 N532VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7804 N533DTDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11362 N533VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 7862 N534DTDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11357 N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705 N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989 N534VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 7941 N535DNDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11424 N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739 N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993 N535VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8087 N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536DNDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11426 N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784 N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025 N536VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8264 N537DTDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11434 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041 N537VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8144 N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398 N538DNDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11436 N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050 N538VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8366 N539DNDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11479 N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082 N539VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8490 N540DEDelta Air Lines Inc · Atlanta, GAS/N 11475 N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107 N541DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11481 N541VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 8844 N542DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11510 N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134 N542VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 8603 N543DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11553 N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843 N543VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 9070

Back to AD 2020-25-03 R1