AD 2018-21-13

Registered aircraft · 240

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:2018-21-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:2018-21-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.

N488TKGalilee II Spv LLC · Bozeman, MTBuilt 2021 · S/N 42000221N48HMAugusta Aviation LLC · Staunton, VABuilt 2018 · S/N 42000113N504YHUrban Green Investments III LLC · San Francisco, CABuilt 2022 · S/N 42000236N510PTPro By Air Inc · Medley, FLBuilt 2023 · S/N 42000251N512KRGohighlands LLC · Saint Augustine, FLBuilt 2016 · S/N 42000036N515HJMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2016 · S/N 42000034N520STLast Minute Flights LLC · Camden, DEBuilt 2021 · S/N 42000210N524HJDodson International Parts Inc · Rantoul, KSBuilt 2017 · S/N 42000077N526BMBuffalo Wings Aviation LLC · Lakewood, NYBuilt 2021 · S/N 42000208N526SHTrofeo Aviation LLC · Helena, MTBuilt 2018 · S/N 42000091N527MWHeart Of America Management LLC · Moline, ILBuilt 2016 · S/N 42000021N529JMJwm Aviation LLC · Camden, DEBuilt 2021 · S/N 42000218N542MPAviation Services The Seventh Inc Owner Trustee · Wilmington, DEBuilt 2025 · S/N 42000285N542MRAviation Services The Third Inc Trustee · Wilmington, DEBuilt 2019 · S/N 42000138N547MPCbga LLC · Belleville, ILBuilt 2017 · S/N 42000070N54DKFive Angels Reagan LLC · Deerfield Beach, FLBuilt 2024 · S/N 42000265N552DBHonda Aviation Service Co Inc · Greensboro, NCBuilt 2017 · S/N 42000061N562DHHeidrich Aviation LLC · Sunset, SCBuilt 2017 · S/N 42000089N570JTEquity Aviation I LLC · Lakeville, MNBuilt 2022 · S/N 42000228N571AGTl Flights IV LLC · Thomasville, GABuilt 2025 · S/N 42000282N577CSGmr Hj LLC · Scottsdale, AZBuilt 2019 · S/N 42000171N57HPIce Man Holdings LLC · Mesa, AZS/N 42000033N605BRContinental 605b Inc Trustee · Wilmington, DEBuilt 2017 · S/N 42000086N60XGEagleone Holdings LLC · Boise, IDBuilt 2017 · S/N 42000053N611JTLeflight Jet LLC · Wilmington, DEBuilt 2022 · S/N 42000235N612PRFlight Safe Inc · Dover, DEBuilt 2017 · S/N 42000046N612SRBay Area/Diablo Petroleum Co · Martinez, CABuilt 2019 · S/N 42000173N615JTRadiqal Aviation LLC · Dover, DEBuilt 2022 · S/N 42000238N617AFCutter Flight Management Inc · Albuquerque, NMBuilt 2018 · S/N 42000122N630WBTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2018 · S/N 42000119N677JTAshland Water Group Inc · Ashland, OHBuilt 2020 · S/N 42000201N682BMCall Michael Val · Afton, WYBuilt 2023 · S/N 42000250N682TMRan Health Services Inc · Modesto, CABuilt 2016 · S/N 42000023N69DHReel Energy Aviation LLC · Placentia, CABuilt 2019 · S/N 42000146N707FHKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2017 · S/N 42000069N715TWMhi Aviation LLC · Saint Rose, LABuilt 2018 · S/N 42000102N718FH315sa LLC · Stilwell, KSS/N 42000041N719FHBr-Mo 78 LLC · Dexter, MOBuilt 2017 · S/N 42000076N719SSDrawe Aviation LLC · Littleton, COBuilt 2020 · S/N 42000188N71TSCapital Holdings 192 LLC · Newark, DEBuilt 2016 · S/N 42000032N72HJOnyx 1 LLC · Boca Raton, FLBuilt 2017 · S/N 42000082N751BP46u LLC · Anaconda, MTBuilt 2023 · S/N 42000245N75VMN75vm LLC · Sheridan, WYBuilt 2021 · S/N 42000215N765MMN765mm LLC · Gary, INBuilt 2023 · S/N 42000259N767AZTrk Aviation LLC · Cheyenne, WYBuilt 2017 · S/N 42000079N77CHonda Aviation Service Co Inc · Greensboro, NCS/N 42000304N77VAHjo LLC · Los Angeles, CABuilt 2025 · S/N 42000281N783JTRivergates Ivy Warp LLC · Boca Raton, FLBuilt 2021 · S/N 42000214N786JTN786jt LLC · Wilmington, DEBuilt 2021 · S/N 42000223N789RJAndersen Air LLC · Idaho Falls, IDFirst renewal noticeBuilt 2019 · S/N 42000172
Back to AD 2018-21-13