Registered aircraft · 883

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-17-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:2017-17-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:2017-17-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:2017-17-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:2017-17-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:2017-17-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.

N809JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20837 N810NMJaya Air LLC · Santa Rosa, CAFirst renewal noticeBuilt 2017 · S/N 20674 N812GHRegistered aircraftBuilt 2021 · S/N 20897 N812KC812kc LLC · Midland, TXBuilt 2014 · S/N 20457 N814AFArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 20633 N815CXConexon LLC · Kansas City, MOBuilt 2013 · S/N 20437 N818NXSilver Monkey LLC · Wheeling, ILBuilt 2016 · S/N 20612 N818RCLegacy Air LLC · Franklin, TNBuilt 2007 · S/N 20165 N818WFSteel Air LLC · Houston, TXBuilt 2012 · S/N 20356 N819JRAutoflight LLC · Pittsburgh, PABuilt 2023 · S/N 20976 N819RSDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 20028 N81CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20176 N81SFBroadway Air Corp · Saint Louis, MOBuilt 2006 · S/N 20138 N822LLPalm Air Holdings LLC · Wellington, FLBuilt 2015 · S/N 20548 N824DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 20507 N824TMRegistered aircraftBuilt 2018 · S/N 20744 N827DDDd Global Direct LLC · Stoughton, MABuilt 2017 · S/N 20670 N828RBRegistered aircraftBuilt 2008 · S/N 20239 N828SKJaztec LLC · Ooltewah, TNS/N 20258 N832LAPacific Real Estate Consulting LLC · Irvine, CABuilt 2008 · S/N 20212 N835JZBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 21112 N837JMJm Aviation Holdings LLC · Deerfield Beach, FLBuilt 2022 · S/N 20918 N838JMJm Aviation Holdings LLC · Deerfield Beach, FLBuilt 2024 · S/N 20997 N839JMJm Aviation Holdings LLC · Deerfield Beach, FLBuilt 2025 · S/N 21047 N841TTSalem Leasing Corp · Winston Salem, NCBuilt 2008 · S/N 20202 N848CSJbw Eagle LLC · Columbus, OHBuilt 2006 · S/N 20139 N84EHEncompass Health Corp · Birmingham, ALBuilt 2023 · S/N 20970 N852DLPnc Financial Services Group Inc · Pittsburgh, PABuilt 2020 · S/N 20840 N855FCFlow Companies LLC · Winston-Salem, NCBuilt 2013 · S/N 20386 N860CMCm Air LLC · Nashville, TNBuilt 2023 · S/N 20945 N861RVLexit Aircraft Holdings LLC · Los Angeles, CABuilt 2004 · S/N 20037 N866HBRegistered aircraftBuilt 2025 · S/N 21103 N866TMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20066 N868LJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 20388 N872HLHl Aircraft LLC · Oklahoma City, OKBuilt 2021 · S/N 20874 N872MJFleet One LLC · Beverly Hills, CABuilt 2020 · S/N 20867 N876CSDouble Standard Advisors LLC · Wilmington, DEBuilt 2010 · S/N 20307 N881CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20891 N883TRTvpx Trust Co LLC Owner Trustee · North Salt Lake, UTBuilt 2010 · S/N 20300 N883TWTrans West Air Service LLC · Boise, IDBuilt 2017 · S/N 20675 N885MBalise Management LLC · West Springfield, MAFirst renewal noticeBuilt 2019 · S/N 20836 N885WWDj Air LLC · Orlando, FLBuilt 2008 · S/N 20225 N886BD886 Aviation LLC · Newport Beach, CABuilt 2008 · S/N 20193 N888KGN888kg LLC · Lehi, UTBuilt 2013 · S/N 20402 N888KRRk 3500 LLC · Delray Beach, FLBuilt 2022 · S/N 20922 N88HDGasair LLC · Fernandina Beach, FLBuilt 2011 · S/N 20344 N88RCK & K Nc Holdings LLC · Concord, NCBuilt 2010 · S/N 20303 N892ABAbfd 3 LLC · Deerfield Beach, FLBuilt 2023 · S/N 20950 N892AEPnc Bank Na · Boise, IDBuilt 2020 · S/N 20850 N893AEPnc Bank Na · Boise, IDBuilt 2020 · S/N 20859

Back to AD 2017-17-13