Skip to content

Registered aircraft · 3,749

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-22-14') 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-22-14') 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-22-14')
    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-22-14')
  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-22-14')
  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-22-14')
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.

N100ACSmith Vicars & Co LLC · Charlottesville, VABuilt 2002 · S/N 5546 N100AKRegistered aircraftBuilt 2016 · S/N 2100 N100FLGhs Leasing Co · Newport Beach, CABuilt 2001 · S/N 5510 N100LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9321 N100QSRegistered aircraftBuilt 2012 · S/N 9480 N100RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9450 N100SAEssay Management Services LLC · Oklahoma City, OKBuilt 2024 · S/N 21019 N100SBA-7 Austin Aviation LLC · Amarillo, TXBuilt 2011 · S/N 525C0061 N100XVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 5320 N100YVb Ultra Transportation LLC · Lake Oswego, ORBuilt 2015 · S/N 525C0204 N100ZTBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 525C0392 N10131013sh LLC · Novato, CABuilt 2008 · S/N 20229 N1019LRegistered aircraftBuilt 2003 · S/N 9125 N101DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 50020 N101GSG&S Aviation LLC · Richland, MSBuilt 2019 · S/N 2190 N101KFTravers 6 LLC · Chesterfield, MOS/N 5564 N101KKKohler Co · Kohler, WIBuilt 2026 · S/N 55020260 N101QSRegistered aircraftBuilt 2012 · S/N 9483 N101RERegistered aircraftBuilt 2017 · S/N 6101 N101UDUnicorp Aviation LLC · Orlando, FLS/N 60015 N101XTXto Energy Inc · Houston, TXBuilt 2016 · S/N 2109 N102CECenterpoint Energy Service Co LLC · Houston, TXBuilt 2020 · S/N 20849 N102DUBank Of Utah Trustee · Salt Lake City, UTS/N 50021 N102PGPape Group Inc · Eugene, ORBuilt 2022 · S/N 2248 N1038S1038s LLC · Austin, TXBuilt 2008 · S/N 5782 N103DUDelta Air Lines Inc · Atlanta, GAS/N 50022 N103SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9129 N104DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9266 N104DUDelta Air Lines Inc · Atlanta, GAS/N 50023 N104QSRegistered aircraftBuilt 2013 · S/N 9555 N105ADComputer Service Professionals Inc DBA · Wilmington, DEBuilt 2010 · S/N 525C-0013 N105DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50024 N106DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50025 N106SPPartee Aviation LLC · Big Spring, TXBuilt 2017 · S/N 55010008 N107DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50026 N1088Fmc Corp · Philadelphia, PABuilt 2009 · S/N 5798 N108DQBank Of Utah Trustee · Salt Lake City, UTS/N 50027 N108ETCarlisle LLC · Scottsdale, AZBuilt 2011 · S/N 20333 N1098LLasai Aviation II LLC · Manassas, VABuilt 2023 · S/N 60098 N109CAJaf Aviation LLC · Englewood, COBuilt 2012 · S/N 525C-0112 N109DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 50028 N109QSRegistered aircraftBuilt 2013 · S/N 9589 N10AUAuburn University · Auburn, ALBuilt 2026 · S/N 525C0493 N10EHReh Finance Co · Salt Lake City, UTBuilt 2019 · S/N 20810 N10GUBusiness Insurance Group LLC · Montgomery, ALBuilt 2016 · S/N 525C0210 N10KJKtkj Challenger LLC · Houston, TXBuilt 2020 · S/N 6155 N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033 N10SERadair LLC · Memphis, TNBuilt 2023 · S/N 20973 N10UNGlobal Air LLC · Nashville, TNBuilt 2018 · S/N 20748 N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354

Back to AD 2017-22-14