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.

N838AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2615 N838UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1477 N839AWAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 2669 N839UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1507 N840AWAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 2690 N840UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1522 N841UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1545 N842UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1569 N843UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1573 N844UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1581 N845UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1585 N846UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1600 N847UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1627 N848UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1647 N849UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1649 N850UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1653 N851ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1185 N851UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1664 N852UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1671 N853UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1688 N854UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1731 N855UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1737 N862AVAircol 23 · Wilmington, DEBuilt 2011 · S/N 4862 N871UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1971 N872UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1986 N873UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 2004 N874UAUmb Bank Na Trustee · Salt Lake City, UTS/N 2008 N875UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2200 N876UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2203 N877UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 2232 N878UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2371 N879UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2408 N880UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2426 N881UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2435 N882UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2505 N883UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2574 N884UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2579 N889UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2667 N890UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2815 N891UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2901 N892UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2940 N893UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2948 N894UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2969 N895UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3020 N896UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3144 N897UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3269 N898UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3311 N899UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3342 N90024Umb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6384 N9002UAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5698

Back to AD 2020-25-03 R1