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.

N552TMPerry Park Investments Inc · Larkspur, COBuilt 2026 · S/N T20609847N553HCHotel Charlie LLC · Dallas, TXBuilt 2004 · S/N T18208287N553HPCalifornia Highway Patrol · Sacramento, CABuilt 2006 · S/N T20608633N553RARich Aviation Services LLC · Fort Worth, TXBuilt 2012 · S/N 172S11176N553TCHawksley LLC · Bozeman, MTBuilt 2004 · S/N T20608487N554EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12873N554TADelta Charlie Aviation LLC · Aliso Viejo, CABuilt 2003 · S/N 172S9455N554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeBuilt 2005 · S/N 18281666N5555DReed Tony S · Mullica Hill, NJBuilt 1999 · S/N 18280459N555CZGreenlawn Realty Co Inc · Columbus, OHS/N 18280325N555ERCherokee Rose Mammography LLC · Macon, GABuilt 1997 · S/N 18280068N555FGTextron Aviation Inc · Wichita, KSS/N 172S13641N555FNFlying Neutrons LLC · Lebanon, OHBuilt 2001 · S/N 17280999N555MMRelativity Inc · Lakeway, TXBuilt 2022 · S/N 18283177N555NVCaladesi Financial Inc · Palm Harbor, FLBuilt 2008 · S/N T18208869N555YSEdb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10638N556ERSunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10561N556NDRainier Flight Service LLC · Renton, WABuilt 2009 · S/N 172S10982N556SPTexas State Technical College · Waco, TXBuilt 1998 · S/N 172S8042N5578MSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2023 · S/N 18283231N557NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10983N558CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13062N558NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10993N558TAGv Air Inc · Medford, ORBuilt 2006 · S/N T20608621N559JRHardie George G Jr · Lancaster, CABuilt 2004 · S/N T18208309N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N559TJHangar 22 LLC · Watkinsville, GABuilt 2000 · S/N 18280852N55LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12063N55RYTwenty Nine Ninety Two LLC · Edina, MNBuilt 2015 · S/N 18282371N55SVSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8488N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668N5618YRegistration Pending · Columbia Falls, MTRegistration pendingBuilt 2004 · S/N T20608471N561CK13622 Capital Holdings LLC · Jacksboro, TNS/N 172S13622N561DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12066N561FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12909N561MBVital Equipment LLC · Midland, TXBuilt 2004 · S/N 18281425N561NDSpartan Education LLC · Tulsa, OKBuilt 2011 · S/N 172S11099N561SAWingsleasing LLC · Wichita, KSBuilt 2004 · S/N 172S9638N561SPIllinois State Police · Springfield, ILBuilt 2000 · S/N 18280825N561XHazelton Gregory C · Dallas, TXFirst renewal noticeBuilt 2006 · S/N T20608660N562ABNavigation Leasing LLC · Castle Rock, COS/N 172S9545N562ACN91934 LLC · Evergreen, COS/N 172S9548N562AEL-Bird LLC · Hood River, ORBuilt 2003 · S/N 172S9553N562AFMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9555N562CBKqm Aviation · Bristow, VABuilt 2010 · S/N 18282207N562FElite Approach LLC · Chesterfield, MOBuilt 2004 · S/N 172S9664N562GKAbney Stanley Don · Patterson, LABuilt 2004 · S/N T18208318N562NDSpartan Education LLC · Tulsa, OKBuilt 2011 · S/N 172S11100
Back to AD 2003-24-13