Skip to content

Registered aircraft · 120

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

N301FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7141 N303FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7249 N304FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7367 N307FRBank Of Utah Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7472 N308FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7538 N309FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7555 N310FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7600 N311FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7642 N312FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7768 N313FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7727 N316FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7824 N317FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 7835 N318FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 7946 N322FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7983 N323FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7925 N324FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7967 N326FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8102 N328FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8118 N329FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8135 N330FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8219 N331FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8239 N332FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8307 N334FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8306 N335FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8320 N336FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8357 N337FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8380 N338FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8402 N339FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8535 N341FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8516 N342FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8537 N343FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8580 N344FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8639 N346FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8642 N347FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8811 N348FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8954 N349FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8766 N350FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8857 N351FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8913 N352FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8976 N353FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 8977 N354FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9026 N356FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9065 N358FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9068 N359FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9177 N360FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9180 N361FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9221 N362FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9222 N363FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9260 N364FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9271 N365FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9340

Back to AD 2019-23-13