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.

N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804 N623JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2504 N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861 N624FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11509 N624JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2520 N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880 N625FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11512 N625JBJetblue Airways Corporation · Long Island City, NYBuilt 2005 · S/N 2535 N625NKUmb Bank Na Trustee · Salt Lake City, UTS/N 5954 N626FRBank Of Utah Trustee · Salt Lake City, UTS/N 11552 N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999 N627JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2577 N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082 N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193 N628VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 2993 N629FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11555 N629JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2580 N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300 N630FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11642 N630JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2640 N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304 N630VABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3101 N631FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11694 N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327 N632AVBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5632 N632JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2647 N633FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11731 N633JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2671 N633NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6345 N633VAAj Aviation Holdings LLC · Miami Springs, FLBuilt 2007 · S/N 3230 N634FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11785 N634JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2710 N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370 N635FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 11837 N635JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2725 N635NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6383 N636FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11839 N636JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2755 N636NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2015 · S/N 6424 N637FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11860 N637JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2781 N637NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6436 N638FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11749 N638JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2802 N638NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6463 N639ACBank Of Utah Trustee · Salt Lake City, UTS/N 1162 N639FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11863 N639JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2814 N639NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6487 N640FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 11973

Back to AD 2020-25-03 R1