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.

N2060JJetblue Airways Corp · Long Island City, NYS/N 9398 N206FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4272 N206NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5289 N207FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4307 N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638 N2084JUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10029 N2086JUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10032 N208HAAlaska Airlines Inc · Seattle, WABuilt 2018 · S/N 8123 N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640 N209HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8186 N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901 N2102JJetblue Airways Corp · Long Island City, NYBuilt 2021 · S/N 10120 N2105JJetblue Airways Corp · Long Island City, NYBuilt 2021 · S/N 10101 N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540 N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442 N212HAAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 8129 N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498 N213HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8237 N2142JJetblue Airways Corp · Long Island City, NYS/N 10254 N214HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8157 N2151JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11336 N2156JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11342 N2157JJetblue Airways Corp · Long Island City, NYBuilt 2023 · S/N 11397 N215HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8266 N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N2165JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11679 N2169JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11695 N216HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8471 N217HAHawaiian Airlines Inc · Seattle, WABuilt 2018 · S/N 8578 N2180JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11838 N2188JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 11955 N218HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 8764 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N2193JJetblue Airways Corp · Long Island City, NYBuilt 2024 · S/N 12274 N2199JJetblue Airways Corp · Long Island City, NYBuilt 2025 · S/N 12288 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N2205JJetblue Airways Corp · Long Island City, NYBuilt 2025 · S/N 12500 N220HAHawaiian Airlines Inc · Seatac, WABuilt 2019 · S/N 8872 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262 N223HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9060 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N226HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9127 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 N227HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 9223 N228HAHawaiian Airlines Inc · Seattle, WABuilt 2019 · S/N 9274 N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716 N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667 N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773 N230HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 9547 N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372

Back to AD 2020-25-03 R1