Skip to content

Registered aircraft · 167

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.

N722GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69788 N723ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 33125 N724ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31548 N725ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41666 N726ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31550 N727ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33541 N728ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31553 N729ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33127 N730ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31554 N731ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33523 N733ARAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33524 N734ARAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31480 N735ATAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 32439 N736ATAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33538 N74007United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29477 N76010United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29480 N76021United Airlines Inc · Chicago, ILBuilt 2010 · S/N 39776 N760GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 68186 N761GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 69033 N769CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 32793 N77012United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29860 N77014United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29862 N77019United Airlines Inc · Chicago, ILBuilt 2007 · S/N 35547 N77022United Airlines Inc · Chicago, ILBuilt 2010 · S/N 39777 N770CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 32792 N771CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 32791 N772CKDae 35607 Trust · Wilmington, DEBuilt 2009 · S/N 35607 N773CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66083 N774CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66084 N775CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66087 N776CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 66815 N777ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 29271 N777SAWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 37989 N778CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 32789 N779CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 32785 N78001United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27577 N78002United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27578 N78003United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27579 N78004United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27580 N78005United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27581 N78008United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29478 N78009United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29479 N78013United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29861 N78017United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31679 N780CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 32787 N79011United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29859 N790CKBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 33865 N791CANational Air Cargo Group Inc DBA · Orlando, FLBuilt 2026 · S/N 70547 N791MFJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 36016 N792CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70548

Back to AD 2017-08-06