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.

N66046Palm Beach Flight Training Corp · Lantana, FLBuilt 2005 · S/N 172S9786N66068Phoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9790N66070Obetz Robert S · Manheim, PABuilt 2005 · S/N 18281522N66083Bravo Zulu Aviation LLC · Torrance, CABuilt 2005 · S/N 172S9938N66085Bellers Aviation Inc · Fremont, CABuilt 2004 · S/N 172S9768N660EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12543N660JWLearning 2 Fly LLC · Cave Creek, AZBuilt 2005 · S/N 172S9788N660SPRobert Devers Solutions · Hermosa Beach, CABuilt 1998 · S/N 172S8065N660TJmta Management LLC · Clinton, MOBuilt 2023 · S/N 18283226N66100Pj Aviation Holding LLC · Eden Prairie, MNBuilt 2004 · S/N T18208335N66104Rhb Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S9781N66135Miller Robert · Pierpont, OHS/N 18281526N66145Liberty Dog Holdings LLC · Tallahassee, FLS/N T20608514N66175Stohlquist James R · Alamosa, COBuilt 2005 · S/N T18208414N66177Newman Ken · Hood River, ORBuilt 2005 · S/N T18208375N66184Sec Fl Corp · Santa Rosa Beach, FLBuilt 2005 · S/N T20608518N661EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12544N661HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2000 · S/N T20608208N661MCSteger Holdings LLC · Georgetown, TXBuilt 2006 · S/N T20608661N661PC661pc LLC · New Rockford, NDBuilt 2004 · S/N T18208312N661SPIllinois State Police · Springfield, ILBuilt 2024 · S/N T20609767N661TW12wam25 LLC · Helena, MTBuilt 2025 · S/N T18209191N662CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283102N662EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12548N662SPCessna N662sp LLC · Duluth, GABuilt 1998 · S/N 172S8066N662TMUpright Corp · Kentfield, CABuilt 2004 · S/N T18208247N663CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12722N663SPN663sp LLC · Stuart, FLS/N 172S8067N663TMAir Freeman LLC · Boca Raton, FLBuilt 2021 · S/N T20609663N664CAChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10135N664CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283357N664EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12549N664PBThomas Anthony Robert Jr · Frederick, MDBuilt 1998 · S/N 18280156N664TMPowell Michael F Trustee · Yerington, NVBuilt 2024 · S/N T20609776N665BCrosby Aviation LLC · Bend, ORBuilt 2001 · S/N T18208011N665BAGroganaire LLC · San Angelo, TXBuilt 2019 · S/N T20609568N665CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12532N665CSPurdue Aviation LLC · West Lafayette, INBuilt 2016 · S/N 172S11665N665HCHenrico County · Henrico, VABuilt 2021 · S/N T20609665N665PWValiair Lc Trustee · Casper, WYBuilt 1999 · S/N 18280494N665RTN665rt LLC · Palm City, FLBuilt 1998 · S/N 17280507N665TATerry Canales Attorney At Law Pllc · Edinburg, TXBuilt 2006 · S/N T20608665N667BLClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13555N667CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 18283236N667EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12556N667SPHindi David · Cupertino, CABuilt 1998 · S/N 172S8070N66888Registered aircraftAssigned (import), pending cancellationS/N 17281380N668CSTom Wood Aviation · Fishers, INBuilt 2016 · S/N 172S11667N668EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12558N669DBEmpire Charters LLC · Ocala, FLBuilt 2009 · S/N T20608921
Back to AD 2003-24-13