OpenAirDocs.org
AD 2017-17-13

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
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.

N738QSRegistered aircraftBuilt 2017 · S/N 20686N739ERegistered aircraftBuilt 2014 · S/N 20446N739QSRegistered aircraftBuilt 2017 · S/N 20690N740QSRegistered aircraftBuilt 2022 · S/N 20927N741ASMurfin Inc · Wichita, KSBuilt 2023 · S/N 20979N741QSRegistered aircraftBuilt 2017 · S/N 20691N7426Bank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 20949N742ERegistered aircraftBuilt 2008 · S/N 20231N742QSRegistered aircraftBuilt 2017 · S/N 20692N743QSRegistered aircraftBuilt 2017 · S/N 20695N743SESouthern Industrial Contractors LLC · Camden, DEBuilt 2024 · S/N 21044N744JW447 LLC · Mesa, AZBuilt 2023 · S/N 20985N744QSRegistered aircraftBuilt 2017 · S/N 20704N745QSRegistered aircraftBuilt 2022 · S/N 20935N746ERegistered aircraftS/N 20207N746QSRegistered aircraftBuilt 2017 · S/N 20709N747CCAir Clayco Inc · Saint Louis, MOS/N 21025N747QSRegistered aircraftBuilt 2017 · S/N 20711N749QSRegistered aircraftBuilt 2017 · S/N 20713N74ZCZiegler Inc · Minneapolis, MNBuilt 2004 · S/N 20018N750QSRegistered aircraftBuilt 2024 · S/N 20994N751ASExecutive Airshare LLC · Overland Park, KSBuilt 2024 · S/N 21043N751QSRegistered aircraftBuilt 2017 · S/N 20716N752MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20210N752QSRegistered aircraftBuilt 2018 · S/N 20720N753QSRegistered aircraftBuilt 2018 · S/N 20722N753RPRp Goals LLC · Wilmington, DEBuilt 2012 · S/N 20383N754QSRegistered aircraftBuilt 2018 · S/N 20732N755ASRegistered aircraftN-number assigned, not yet registeredS/N 21144N755QSRegistered aircraftBuilt 2018 · S/N 20737N756HATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2019 · S/N 20815N756QSRegistered aircraftBuilt 2018 · S/N 20742N757CCAir Clayco Inc · Saint Louis, MOS/N 20762N757QSRegistered aircraftBuilt 2018 · S/N 20746N758QSRegistered aircraftBuilt 2018 · S/N 20750N759QSRegistered aircraftBuilt 2018 · S/N 20753N760HCDec LLC · Atlanta, GABuilt 2019 · S/N 20813N760QSRegistered aircraftBuilt 2018 · S/N 20755N761QSRegistered aircraftBuilt 2018 · S/N 20759N763LCLamar Air LLC · Baton Rouge, LABuilt 2020 · S/N 20863N763MTPacific Challenger Aircraft Services LLC · Scottsdale, AZBuilt 2008 · S/N 20206N764WSWestad Leasing LLC · Cincinnati, OHBuilt 2024 · S/N 21004N765QSRegistered aircraftBuilt 2014 · S/N 20523N765RRBpo LLC · Fishers, INS/N 20602N766QSRegistered aircraftBuilt 2014 · S/N 20526N7670BOb Air LLC · Bellevue, WABuilt 2010 · S/N 20299N767QSRegistered aircraftBuilt 2014 · S/N 20533N768QSRegistered aircraftBuilt 2014 · S/N 20534N769QSRegistered aircraftBuilt 2015 · S/N 20539N769RFFinair LLC · Charlotte, NCBuilt 2010 · S/N 20289
Back to AD 2017-17-13