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.

N7264HDelta Sierra Aviation LLC · White Salmon, WABuilt 1999 · S/N T20608103N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807N72658Tidewater Flying Club Inc · Newport News, VABuilt 1999 · S/N 18280643N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749N7265REmerald City Aircraft Leasing Inc · Port Orchard, WAS/N T20608045N7265YAv8r LLC · Manchester Center, VTBuilt 1999 · S/N 17280768N7265ZAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280769N72662Jwa Flight School LLC · Bolingbrook, ILBuilt 1999 · S/N 17280817N72664Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280818N72667Rro Leasing LLC · Grand Forks, NDBuilt 1999 · S/N 18280652N72669Mid-Island Air Service Inc · Ronkonkoma, NYBuilt 1999 · S/N 18280496N7266BButtonwood Construction LLC · Islamorada, FLBuilt 2001 · S/N T18208003N7266MFerrarer Joseph H Trustee · Glendora, CABuilt 1999 · S/N 18280619N7266NBeck Robert A · Cove, ORS/N 20608058N7266YAvero Aviation LLC · Dover, DEBuilt 1999 · S/N 20608059N7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1999 · S/N 20608060N72671Vfr Aircraft And Training LLC · Jackson, MOBuilt 1999 · S/N 18280495N72675Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2001 · S/N 172S8977N7267TDmcc LLC · Lewes, DEBuilt 1999 · S/N 18280523N7267YVolatilis Aviation LLC · Collinsville, ILS/N 18280500N7267ZHoffpauir Jeremy · Broussard, LABuilt 1999 · S/N 18280525N72689Brown Nathan · Snellville, GABuilt 2000 · S/N 18280820N7268FFarber Gerald · Las Cruces, NMBuilt 1999 · S/N 18280527N7268GSteel & Supply Co LLC · Pensacola, FLBuilt 1999 · S/N 18280528N7268KFelts Field Flying Club · Spokane Valley, WABuilt 1999 · S/N 18280491N7268PSurdex Corp · Chesterfield, MOBuilt 1999 · S/N T20608043N7268Y612 Holdings Lp · Decatur, TXS/N T20608046N7268ZWestwind Aviation Inc · Phoenix, AZBuilt 1999 · S/N T20608048N72692Mccurdy Dwight B · Anderson, INBuilt 2000 · S/N 20608139N7269416 Sandals LLC · Tuscaloosa, ALBuilt 1999 · S/N 18280479N72695Surdex Corp · Chesterfield, MOBuilt 2001 · S/N T20608274N72696Bass Adventures LLC · Anchorage, AKBuilt 2001 · S/N T20608270N72697Cbt Aviation LLC · Bellingham, WABuilt 1999 · S/N 20608031N7269BReece Vance · Winnsboro, TXBuilt 1999 · S/N 18280490N7269CCollins Carliss Alvin · Andrews, TXBuilt 1999 · S/N T20608055N7269KDeatley Crushing Company Inc · Lewiston, IDBuilt 1999 · S/N T20608056N7269TAg N7269t LLC · Salt Lake City, UTBuilt 1999 · S/N T20608050N7269XCummings Cove Air LLC · Gloucester, MAS/N T20608054N726CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11566N726ECHeritage Aviation Management Ltd · Conroe, TXBuilt 2021 · S/N T20609635N726EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13029N726GMNby Productions · Bristow, VABuilt 2021 · S/N T20609644N726LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13587N726MPBryant Darrell · Treasure Island, FLBuilt 2023 · S/N T20609751N726SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 18282221N7270HSundowners Inc · Fort Myers, FLBuilt 1999 · S/N 18280481N7270QGrey-Gc LLC · Picayune, MSBuilt 1999 · S/N 18280484N7270YBlanton Kenneth A Jr · Cortland, NYBuilt 1999 · S/N 18280498N7271XAeolian LLC · Mcalester, OKBuilt 1999 · S/N 18280518N7271YVitatoe Industries Inc · Chillicothe, OHBuilt 1999 · S/N T20608069
Back to AD 2003-24-13