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.

N770QSRegistered aircraftBuilt 2015 · S/N 20543N771QSRegistered aircraftBuilt 2018 · S/N 20766N772JSSchnitzer Air LLC · Portland, ORBuilt 2007 · S/N 20153N773QSRegistered aircraftBuilt 2018 · S/N 20773N773RCRcm Aviation LLC · Atlanta, GABuilt 2014 · S/N 20448N774QSRegistered aircraftBuilt 2015 · S/N 20554N776CJTaldav Holdings Two LLC · West Palm Beach, FLBuilt 2006 · S/N 20107N776QSRegistered aircraftBuilt 2015 · S/N 20558N7778JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20436N777DYNevada Restuarant Services Inc · Bozeman, MTBuilt 2025 · S/N 21062N777MSKgc Aviation LLC · Las Vegas, NVBuilt 2007 · S/N 20168N777NEAtlantic Transportation Of Wilmington LLC · Wilmington, NCBuilt 2022 · S/N 20903N777QSRegistered aircraftBuilt 2015 · S/N 20562N778QSRegistered aircraftBuilt 2015 · S/N 20563N779QSRegistered aircraftBuilt 2015 · S/N 20566N780QSRegistered aircraftBuilt 2015 · S/N 20568N781QSRegistered aircraftBuilt 2015 · S/N 20570N782QSRegistered aircraftBuilt 2015 · S/N 20561N783QSRegistered aircraftBuilt 2015 · S/N 20574N784QSRegistered aircraftBuilt 2015 · S/N 20575N786QSRegistered aircraftBuilt 2015 · S/N 20590N787LPDobbs Baron II LLC · Memphis, TNBuilt 2019 · S/N 20835N787QSRegistered aircraftBuilt 2015 · S/N 20595N788QSRegistered aircraftBuilt 2016 · S/N 20607N789QSRegistered aircraftBuilt 2016 · S/N 20617N78TCTimken Co · North Canton, OHBuilt 2005 · S/N 20070N790NEBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 21104N790QSRegistered aircraftBuilt 2016 · S/N 20627N791QSRegistered aircraftBuilt 2016 · S/N 20629N792QSRegistered aircraftBuilt 2016 · S/N 20634N793QSRegistered aircraftBuilt 2016 · S/N 20636N794QSRegistered aircraftBuilt 2016 · S/N 20638N795QSRegistered aircraftBuilt 2016 · S/N 20641N796QSRegistered aircraftBuilt 2016 · S/N 20646N797CBJs Aviation LLC · Lewisville, TXBuilt 2007 · S/N 20158N797CSRitchie Park LLC · Scottsdale, AZBuilt 2008 · S/N 20197N797QSRegistered aircraftBuilt 2016 · S/N 20648N798QSRegistered aircraftBuilt 2016 · S/N 20655N798SBSky Bound LLC · Pleasant Grove, UTBuilt 2017 · S/N 20679N799QSRegistered aircraftBuilt 2016 · S/N 20656N7CACooper Family Management Co LLC · Oklahoma City, OKBuilt 2004 · S/N 20031N7NYNyy Seven Aviation LLC · Rexford, NYBuilt 2008 · S/N 20248N7PWFlying W LLC · Lake Wales, FLBuilt 2008 · S/N 20244N800BDRegistered aircraftBuilt 2009 · S/N 20270N800BWBorg Warner Inc · Auburn Hills, MIBuilt 2019 · S/N 20800N800SBMarker 7 LLC · Wilmington, DEBuilt 2024 · S/N 20992N801KLRegistered aircraftBuilt 2014 · S/N 20503N806PHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20086N807BGBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 21036N808NCAloysius Air LLC · Wilmington, DEBuilt 2006 · S/N 20106
Back to AD 2017-17-13