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.

N591CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282176N5929TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2002 · S/N 17281105N592CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12731N592JSStraut James M · Upper Saddle River, NJS/N 18281041N593CPCivil Air Patrol · Montgomery, ALS/N 18282178N594CMCameron John B · Iredell, TXBuilt 2004 · S/N T18208332N594CPCivil Air Patrol · Maxwell Afb, ALS/N 18282180N594QHager Cecilia J · Fredericksburg, TXBuilt 1999 · S/N T20608024N594SMGpi Geospatial Inc · Orlando, FLBuilt 2017 · S/N T20609235N595DBStar Magic (Www) Inc · New York, NYBuilt 2005 · S/N 172S9876N595MSClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13558N595PZSomid Resources LLC · Choudrant, LABuilt 2022 · S/N 172S12840N595SPSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2000 · S/N 172S8522N5961JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11610N596CSVan Anda Aviation LLC · Apopka, FLBuilt 1997 · S/N 17280050N596FAOcala Aviation Services Inc · Ocala, FLBuilt 2004 · S/N 172S9596N597DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12068N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525N597TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13229N598MCTeichroeb Peter · Seminole, TXBuilt 1998 · S/N 18280206N598SPFb Aviation LLC · Minot, MEBuilt 2000 · S/N 172S8526N599TSNbr Aviation · Bristow, VABuilt 2015 · S/N T20609169N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359N59FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12933N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043N59TWAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13249N6000VTextron Aviation Inc · Wichita, KSS/N 172S13603N60030Jmj Properties LLC · Atchison, KSBuilt 2006 · S/N T18208500N6004LJackson Mac Roy Jr · Hood River, ORS/N T18208506N6004YYyky LLC · Walnut Creek, CABuilt 2006 · S/N T18208509N60051Compass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283355N60053Textron Aviation Inc · Wichita, KSS/N 172S13650N6005JTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283353N6005SCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283354N60062Textron Aviation Inc · Wichita, KSS/N 172S13656N6006XTextron Aviation Inc · Wichita, KSS/N 172S13657N6007ATextron Aviation Inc · Wichita, KSS/N 172S13651N6009MKd 172 Ventures I LLC · Bellevue, WABuilt 2006 · S/N 172S10134N6009POh Air LLC · Mentor, OHBuilt 2006 · S/N 172S10137N6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeBuilt 2006 · S/N 172S10138N600PKGetzel Air LLC · Conover, WIBuilt 2008 · S/N 18282082N6012U6012u LLC · Union Gap, WABuilt 2006 · S/N 172S10168N6012ZChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10150N6013JAerodrome LLC · Louisville, KYBuilt 2006 · S/N 172S10153N6013KLdm LLC · Cuba, MOBuilt 2006 · S/N 18281795N6013SStomio LLC · Covina, CABuilt 2006 · S/N 18281797N6013VFlynn James H Jr · Saratoga Springs, NYBuilt 2006 · S/N 18281798N60143H2 Link Company · Lewes, DEBuilt 2008 · S/N 172S10142N6014GBennett Michelle D · Middletown, NJBuilt 2006 · S/N T18208530N6014JDue West Aviation LLC · Gypsum, COBuilt 2006 · S/N T18208531
Back to AD 2003-24-13