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.

N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746NKAlc A321 92024 LLC · Los Angeles, CABuilt 2025 · S/N 12423 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297 N74751Umb Bank Na Trustee · Salt Lake City, UTS/N 13170 N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301 N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862 N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311 N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313 N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120 N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315 N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317 N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319 N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326 N754UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1328 N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7437 N755USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1331 N756USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1340 N757UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1342 N758USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1348 N760JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3659 N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354 N762AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2019 · S/N 8889 N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358 N763AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4763 N763JBJetblue Airways Corp · Long Island, NYBuilt 2008 · S/N 3707 N763USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1360 N764AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7887 N764USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1369 N765AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7928 N765USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1371 N766AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8096 N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724 N766USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1378 N767UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1382 N768JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3760 N768USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1389 N769AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8170 N769USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1391 N770UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2000 · S/N 1393 N771XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1980 N772XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1997 N773XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2012 N774XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2019 N775AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8240 N775JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3800 N775XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2198 N776AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8280 N776XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2209 N778XFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4127

Back to AD 2020-25-03 R1