Skip to content

Registered aircraft · 166

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

N118DSBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 37704 N2135UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62646 N2136UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62648 N2138UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62649 N2140UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62651 N2142UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63722 N220XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29739 N2243UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63723 N2250UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66590 N2251UUnited Airlines Inc · Chicago, ILBuilt 2020 · S/N 66591 N2331UUnited Airlines Inc · Chicago, ILBuilt 2016 · S/N 62642 N2332UUnited Airlines Inc · Chicago, ILBuilt 2016 · S/N 62643 N2333UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62644 N2341UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63721 N2352UUnited Airlines Inc · Chicago, ILBuilt 2020 · S/N 66592 N2534UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62645 N2639UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62650 N2644UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63724 N2645UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64989 N27015United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28678 N2737UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62647 N2747UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64991 N2748UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64994 N2749UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66589 N2846UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64990 N37018United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31680 N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741 N463ACUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35299 N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679 N60VLBank Of Utah Trustee · Salt Lake City, UTS/N 39254 N69020United Airlines Inc · Chicago, ILBuilt 2007 · S/N 31687 N702GTU S Bank Na Trustee · Hartford, CTBuilt 2012 · S/N 38091 N703GTUS Bank Na Trustee · Hartford, CTBuilt 2012 · S/N 41518 N704GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35606 N705DNJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 29742 N707GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 67992 N708GTUmb Bank & Trust Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67993 N709DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 40559 N709GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 67994 N70VLBank Of Utah Trustee · Salt Lake City, UTS/N 30440 N710DNJetran LLC · Horseshoe Bay, TXBuilt 2010 · S/N 40560 N710GTTitan Aviation Leasing Ltd - Americas Inc · Purchase, NYBuilt 2023 · S/N 67995 N712GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69787 N714SAWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 37988 N717ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 31543 N718ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 41665 N719ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41668 N720ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33522 N721ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31546 N722ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31547

Back to AD 2017-08-06