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.

N702FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6825 N702NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11328 N702UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 1998 · S/N 0896 N703DHBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 13353 N703JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3381 N703NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11383 N703UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0904 N704DVBank Of Utah Trustee · Salt Lake City, UTS/N 13379 N704FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6845 N704USUmb Bank N A Trustee · Salt Lake City, UTBuilt 1998 · S/N 0922 N705FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6891 N705JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3416 N705NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11608 N705UWBank Of Utah Trustee · Salt Lake City, UTS/N 0929 N706DLBank Of Utah Trustee · Salt Lake City, UTS/N 13647 N706FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6926 N706JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3451 N706NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11427 N708FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 7042 N708JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3479 N708NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11605 N708UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0972 N709FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7097 N709JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3488 N709NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11470 N709UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0997 N710FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7179 N710NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11458 N710UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 1999 · S/N 1019 N711FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7184 N711UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1033 N712FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7204 N712JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3517 N712NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 11570 N712USBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1038 N713FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7286 N713NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11789 N713UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1040 N714FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7294 N714USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1046 N715FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7313 N715JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3554 N715NKMagnifica Air1 LLC · Windermere, FLBuilt 2024 · S/N 11788 N715UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1051 N716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7524 N716NKAlc A321 102023 LLC · Los Angeles, CABuilt 2024 · S/N 11880 N716UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1055 N717FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7536 N717NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 11851 N717UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1069

Back to AD 2020-25-03 R1