Skip to content

Registered aircraft · 68

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

N183AMAlc B879 60285 LLC · Camden, DEBuilt 2016 · S/N 60285 N20904United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34824 N24972United Airlines Inc · Chicago, ILBuilt 2018 · S/N 40939 N24973United Airlines Inc · Chicago, ILBuilt 2018 · S/N 40941 N26902United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34822 N26906United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34829 N27901United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34821 N27903United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34823 N29971United Airlines Inc · Chicago, ILBuilt 2017 · S/N 60147 N29978United Airlines Inc · Chicago, ILBuilt 2020 · S/N 66137 N438AMBc2 43862 LLC · Camden, DEBuilt 2017 · S/N 43862 N45905United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34825 N605UPC C & E I LLC · Louisville, KYBuilt 2017 · S/N 64252 N606UPCc & E I LLC · Louisville, KYBuilt 2017 · S/N 64253 N607UPC C & E I LLC · Louisville, KYBuilt 2017 · S/N 64265 N608UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64255 N609UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64254 N610UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64256 N611UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64257 N612UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64258 N613UPC C & E I LLC · Louisville, KYBuilt 2018 · S/N 64259 N614UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 64260 N615UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 64261 N616UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 64262 N617UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 64263 N618UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 64264 N620UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65787 N621UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65785 N622UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65784 N623UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65783 N624UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 63784 N625UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65782 N626UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65781 N627UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65780 N628UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65779 N629UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65778 N630UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65777 N631UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 65776 N632UPUnited Parcel Service Co · Louisville, KYBuilt 2022 · S/N 65775 N633UPUnited Parcel Service Co · Louisville, KYBuilt 2022 · S/N 65774 N634UPUnited Parcel Service Co · Louisville, KYBuilt 2013 · S/N 37564 N635UPUnited Parcel Service Co · Louisville, KYBuilt 2017 · S/N 63199 N7478ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 37829 N747EFSierra Nevada Company LLC · Sparks, NVBuilt 2015 · S/N 40906 N747SNSierra Nevada Company LLC · Sparks, NVBuilt 2015 · S/N 40907 N748GMSierra Nevada Company LLC · Sparks, NVBuilt 2015 · S/N 40908 N828AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40648 N835ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40655 N850GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37570 N851GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37565

Back to AD 2018-21-12