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.

N952XVAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7861 N953NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10686 N953XVAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 7942 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725 N954NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10697 N954XVAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7999 N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835 N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757 N955NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10812 N955XVAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 8120 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791 N956NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10857 N956XVAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 8126 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809 N957XVAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 8246 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859 N958NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10860 N958XVAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 8819 N959AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6110 N959JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6903 N959XVAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 8829 N960AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6125 N961AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3961 N961JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6930 N962AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10781 N962JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6988 N962NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 11056 N963AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10802 N963NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 11088 N964AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10842 N964JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7018 N964NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 11079 N965AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11140 N965JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6512 N965NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 11124 N966ADBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1966 N966ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1241 N966AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11213 N966JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7230 N966NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 11188 N967AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11219 N967JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7257 N967NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 11128 N968JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7305 N968NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 11151 N969JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7353

Back to AD 2020-25-03 R1