Skip to content

Registered aircraft · 1,631

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:2018-17-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21') 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:2018-17-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
  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:2018-17-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-21')
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.

N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304 N630VABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3101 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 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 N634JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2710 N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370 N635JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2725 N635NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6383 N636JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2755 N636NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2015 · S/N 6424 N637JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2781 N637NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6436 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 N639JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2814 N639NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6487 N640JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2832 N640NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6507 N641JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2848 N641NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6566 N642NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6586 N642VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3670 N643JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2871 N643NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6616 N644JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2880 N644NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7156 N645ACBank Of Utah Trustee · Salt Lake City, UTS/N 1259 N645JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2900 N645NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7008 N646JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2945 N646NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7062 N647AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3647 N647AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1997 · S/N 762 N647NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7635 N648JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2970 N648NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7656 N649AWBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 803 N649JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2977 N649NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7679 N650AWU S Bank N A Trustee · Boston, MABuilt 1998 · S/N 856 N650NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7724 N651AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 866 N651JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 2992 N651NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8018 N652AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 0953

Back to AD 2018-17-21