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.

N511DEDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 10979 N511VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5212 N512DEDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11069 N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308 N513DADelta Air Lines Inc · Atlanta, GAS/N 10998 N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322 N514DEDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11126 N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337 N515DEDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11141 N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391 N516DADelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11004 N516JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1302 N517DNDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11078 N517JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1327 N518DQDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11122 N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488 N519AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5119 N519DTDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11198 N519JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1398 N519UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3881 N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510 N520DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11176 N520JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1446 N520VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5595 N521DTDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11082 N521JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1452 N521SHGlobal Crossing Airlines Inc · Miami, FLS/N 2840 N521UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3944 N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651 N522DADelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11154 N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776 N523DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11236 N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506 N523UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3960 N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014 N524DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11207 N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528 N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977 N524VAN524va Trust · Wilmington, DEBuilt 2007 · S/N 3204 N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161 N525DADelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11246 N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332 N526DEDelta Air Lines Inc · Atlanta, GABuilt 2022 · S/N 11174 N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546 N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527DEDelta Air Lines Inc · Atlanta, GABuilt 2023 · S/N 11272 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978 N527VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3417 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705

Back to AD 2020-25-03 R1