AD 2023-17-13

Registered aircraft · 1,956

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

N148BAMorledge-Hampton Scott · Billings, MTBuilt 2018 · S/N 00053N148SRTansky Stanley S · Logan, OHBuilt 2010 · S/N IDK395CN1494TSouthern Flyers Eaa Chapter 1494 Inc · Dandridge, TNBuilt 2026 · S/N 121632N14EPBatterman Eric P · Princeton, NJBuilt 2009 · S/N 1DK399CN14PMVerzwyvelt Michael W · Twin Falls, IDBuilt 2017 · S/N KA17009342N1507JSmith Charles L · La Marque, TXBuilt 2021 · S/N 121086N150JLLengacher John · Cannelburg, INBuilt 2023 · S/N 0109N150RTRt Aviation LLC · Laurel, MSBuilt 2025 · S/N FNG460325AN151SGGurevich Alan · Seattle, WABuilt 2021 · S/N 12-041N152BABank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 00186N152GHatfield Keith A · Dallas, TXBuilt 2012 · S/N 000588N152RXPhelps Rex D · Macomb, MIBuilt 2021 · S/N KA11250211N152SGSuedla Holding LLC · Wilmington, DEBuilt 2022 · S/N 12-045N152TUCampbell Steven G · Newport Beach, CABuilt 2016 · S/N 052N152WPCook Christopher M · Twin Falls, IDS/N 04-285N1538ZAno Build One · Plattsmouth, NEBuilt 2020 · S/N 121037N153WPFlamingo Aviation LLC · Bend, ORBuilt 2006 · S/N 04-286N154RMurphys Auto Gyro Sales LLC · Dade City, FLBuilt 2020 · S/N 0044N155BADhv Aviation LLC · Haverhill, FLBuilt 2018 · S/N 00056N155MLawton John Mann · Whitwell, TNBuilt 2018 · S/N 53418N15629Williams Donald B · Wingate, NCBuilt 1994 · S/N 0693111N1564Stick & Rudder LLC · London, KYBuilt 2015 · S/N 160/2015N156BAUltralight Sport Aviation LLC · Union, MIBuilt 2019 · S/N 00073N156TXDucote Kendall J · Prairieville, LABuilt 2008 · S/N PC120791P504N156WSDryden Everett R · Wolcott, VTBuilt 1999 · S/N 1190-0399-7-W993N157KSMulvey Airplanes LLC · Lockport, NYBuilt 2017 · S/N KA16078327N158BASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2023 · S/N 00189N158MBKropelin Barry R · Waxhaw, NCBuilt 2020 · S/N 08175451014N159BAMichellcona5 LLC · Brooklyn, NYS/N 00076N161BAPrecocity Academy LLC · Gibsonia, PABuilt 2019 · S/N 00079N161RNWaterwings Seaplanes LLC · Hoover, ALBuilt 2005 · S/N AC061N162BAAtec Aviation LLC · Jupiter, FLBuilt 2019 · S/N 00081N1632AUmatilla Rv LLC · Umatilla, FLBuilt 2024 · S/N 121188N163BLHenry Steven T · Auburn, NHBuilt 2018 · S/N 363/2018N164XStetson Jeffry W · East Lansing, MIFirst renewal noticeBuilt 2005 · S/N 200164N164YSling Rental Aviation · Laguna Beach, CABuilt 2013 · S/N 130N165CBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N IMK387CN166KWalker Troy L · Greenville, ILBuilt 2008 · S/N 0707468N166KMKc Mead Bristell LLC · Brownsville, WIBuilt 2019 · S/N 395-2019N1672LPike Phillip M · Saint Petersburg, FLFirst renewal noticeBuilt 2000 · S/N 7617N167BLSport Flying USA Inc · Remsenburg, NYBuilt 2016 · S/N 167/2015N167TUHawkins Flight Academy LLC · Shelbyville, TNS/N 167/USN1682WDavis Chad A · Luana, IABuilt 2004 · S/N 1100088N1688BChen Chris · Monrovia, CABuilt 2013 · S/N V00123N168DADynasty Aviation Inc · Pembroke Pines, FLBuilt 2021 · S/N 338N168MBNemec David M · Helendale, CABuilt 2007 · S/N 125-07-02N168TWShin Richard C · Torrance, CABuilt 2014 · S/N 155N16BAOwen Aviation Co LLC · Meridian, MSBuilt 2020 · S/N 16202693N16BMWilson Joshua A · Mckinney, TXBuilt 2022 · S/N PM007N16ENDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2016 · S/N 305
Back to AD 2023-17-13