AD 2003-24-13

Registered aircraft · 7,870

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:2003-24-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:2003-24-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.

N23KRUniversity Of Central Missouri · Warrensburg, MOBuilt 2023 · S/N 172S12952N23NPAia Foxtrot LLC · Henderson, NVBuilt 2023 · S/N 172S12984N23SKPlainsman Aviation LLC · Kalispell, MTBuilt 2023 · S/N T18209129N23TLLottman Aviation LLC · Beatrice, NEBuilt 2004 · S/N 18281503N23VGPainted Horse Holding LLC · New Town, NDBuilt 2013 · S/N T18209099N23VMOrange Skies LLC · Great Falls, VABuilt 2018 · S/N T20609533N23YPBmf Jax LLC · Jacksonville, FLS/N 18281468N23YRP R Parker Company Inc · Shreveport, LABuilt 2015 · S/N 18282379N2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2000 · S/N T20608160N2401AWhite Pat J · Wellington, TXBuilt 2006 · S/N 18281755N2405SJohn L Lyle Aviation LLC · Ridgeland, MSBuilt 2006 · S/N 18281759N2407NPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10550N2409ENutac Leasing LLC · Deland, FLBuilt 2007 · S/N 172S10552N240CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N T20609069N240CSSem Assets LLC · Carrollton, TXBuilt 2024 · S/N T18209140N240CTCoast Flight Training & Management Inc · San Diego, CABuilt 2006 · S/N 17281352N240DCWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281099N240PSN240ps LLC · Mesa, AZBuilt 2012 · S/N T20609081N240TBN54za LLC · Houston, TXBuilt 2024 · S/N T20609742N24108Svetfur Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10504N24129Ssi Aviation Group LLC · Eagle, IDBuilt 2007 · S/N T18208756N2412WWestern Edge Aviation LLC · Dickinson, NDBuilt 2007 · S/N 172S10557N2413M2021 Liberty Air LLC · Santa Rosa, CAS/N T18208758N24144Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10558N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927N241ABTextron Aviation Inc · Wichita, KSS/N 172S13627N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313N241KRMako Offshore Exploration Inc · Pagosa Springs, COBuilt 2004 · S/N T18208326N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761N241MPGv Air Inc · Medford, ORBuilt 2011 · S/N T20609035N24200Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13114N24201Suhr Douglas Henry Jr · Oil City, PABuilt 2007 · S/N 18281954N24204Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13115N24205Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13116N24207Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13118N24210Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13122N24213Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13124N24215Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13128N24218Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13129N24219Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13130N24221Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13131N24222Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13132N24223Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13133N24226Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13134N24236Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13135N24237Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13136N24238Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13139N24239Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13142
Back to AD 2003-24-13