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.

N655FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 12176 N655JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3072 N655NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8376 N656AWU S Bank N A Trustee · Boston, MABuilt 1999 · S/N 1079 N656FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 12261 N656JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3091 N656NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8400 N657AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1083 N657FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 12276 N657JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3119 N658AWWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 1110 N658FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 12216 N658JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3150 N658NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6736 N659AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1166 N659FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 12905 N659JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3190 N659NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6770 N660AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1234 N660FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 12224 N660NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6804 N661AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1284 N661JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3228 N661NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6867 N662AWUS Bank National Association Trustee · Boston, MABuilt 2000 · S/N 1274 N662FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 12297 N662JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3263 N662NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6897 N663AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1419 N663FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 12394 N663JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3287 N663NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 6994 N664AVAvsa Leasing 3 · Wilmington, DEBuilt 2008 · S/N 3664 N664AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1621 N664FRBank Of Utah Inc Trustee · Salt Lake City, UTBuilt 2025 · S/N 12302 N664NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7021 N665AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1644 N665FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 12390 N665JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3348 N665NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7045 N667AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1710 N667FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 12525 N667NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7058 N668AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1764 N668FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 12486 N668NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7135 N668SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 963 N669AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1792 N669FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 12527 N669NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7296

Back to AD 2020-25-03 R1