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.

N713UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1040 N714FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7294 N714USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1046 N715FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7313 N715JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3554 N715UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1051 N716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7524 N716UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1055 N717FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7536 N717UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1069 N718FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7575 N719FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 7736 N720FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7852 N721FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7884 N721UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1095 N722FRAlc A321 8579 LLC · Camden, DEBuilt 2018 · S/N 8579 N722USBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1097 N723FRAlc A321 8640 LLC · Camden, DEBuilt 2018 · S/N 8640 N723UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1109 N724AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6153 N724UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1122 N725UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1135 N728AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6209 N729JBJetblue Airways Corp · Long Island City, NYS/N 3572 N730AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6132 N730USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1182 N732USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1203 N733UWAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1205 N737USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1245 N738USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1254 N740AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6411 N740UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1265 N741UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1269 N742AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6692 N742PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1275 N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739 N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287 N745AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6746 N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297 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

Back to AD 2000-05-21