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.

N391DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9027 N391FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10838 N392DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9028 N392FRWilmington Trust Co Trustee · Wilmington, DES/N 10833 N393DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9067 N393FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10919 N394DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9125 N394FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10981 N395DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9126 N395FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11077 N396DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9128 N396FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11155 N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982 N397DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9176 N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988 N398DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9360 N4005XAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5753 N400ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8647 N401ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8701 N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001 N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435 N4022JJetblue Airways Corp · Long Island City, NYBuilt 2021 · S/N 10303 N402ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8750 N402FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 12857 N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439 N4032TAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6644 N403ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8780 N4048JJetblue Airways Corp · Long Island City, NYBuilt 2021 · S/N 10446 N404ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8758 N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450 N4058JJetblue Airways Corporation · Long Island City, NYBuilt 2021 · S/N 10619 N405ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8800 N405FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 12896 N4062JJetblue Airways Corp · Long Island City, NYBuilt 2022 · S/N 10839 N4064JJetblue Airways Corp · Long Island City, NYBuilt 2022 · S/N 10861 N406ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8834 N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454 N4073JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11129 N4074JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11354 N4076JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11513 N4077JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11604 N407ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8898 N4080JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11861 N4083JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11903 N408ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 9083 N409AABank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9178 N409FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 12900 N410ACBank Of Utah Trustee · Salt Lake City, UTS/N 3045 N410ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9134 N410GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 01199

Back to AD 2020-25-03 R1