Skip to content

Registered aircraft · 1,354

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:2000-05-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:2000-05-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:2000-05-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:2000-05-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:2000-05-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:2000-05-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.

N679NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7825 N680AWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2005 · S/N 2630 N680NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7870 N681NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7908 N682NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7957 N683NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8114 N684AJUnited Aircraft Industries · Newark, DES/N 0194 N684NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8047 N685NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8115 N686NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8141 N686TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5238 N687NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8160 N688TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5243 N689TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5333 N690NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8434 N691NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8614 N692NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8611 N693NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8659 N694NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8632 N696NKSpirit Airlines LLC · Dania Beach, FLBuilt 2019 · S/N 8824 N700UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0885 N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359 N701FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6793 N701UWUmb Bank Trustee · Salt Lake City, UTBuilt 1998 · S/N 0890 N702FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6825 N702UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 1998 · S/N 0896 N703JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3381 N703UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0904 N704FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6845 N704USUmb Bank N A Trustee · Salt Lake City, UTBuilt 1998 · S/N 0922 N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546 N705FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6891 N705JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3416 N705UWBank Of Utah Trustee · Salt Lake City, UTS/N 0929 N706FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6926 N706JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3451 N708FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 7042 N708JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3479 N708UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0972 N709FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7097 N709JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3488 N709UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0997 N710FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7179 N710UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 1999 · S/N 1019 N711FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7184 N711UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1033 N712FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7204 N712JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3517 N712USBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1038 N713FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7286

Back to AD 2000-05-21