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.

N5253CMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10906N5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CABuilt 2002 · S/N 172S9169N5254ABuffy Aero LLC · Suwanee, GABuilt 2002 · S/N 18281157N5254QRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2002 · S/N 172S9206N5254WGlacier Peak Aviation LLC · Carnation, WABuilt 2002 · S/N 172S9207N5255RZin Services LLC · Dover, DEBuilt 2009 · S/N 172S10987N5256SFargo Jet Center LLC · Fargo, NDBuilt 2009 · S/N 172S10901N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181N5258YChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9141N525MJCohen Heath P · Lake Havasu City, AZBuilt 2006 · S/N T18208533N525NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10817N52606Cirrus Aviation Inc · Sarasota, FLBuilt 2009 · S/N 172S10995N5262QReinhart Gregory D · Waunakee, WIBuilt 2009 · S/N T18208975N5262UL&W Aircraft Investment LLC · Homestead, FLBuilt 2002 · S/N 172S9175N5262YLead Turn Aviation LLC · Ogden, UTBuilt 2002 · S/N 172S9176N52642Valiair Ltd Co Trustee · Casper, WYBuilt 2009 · S/N T20608946N5264RHenslee Aviation LLC · Hobbs, NMBuilt 2009 · S/N T18208982N52657Honeycutt Holdings Inc · Charlotte, NCS/N T18208172N5266GMtf Aviation LLC · Salem, ILBuilt 2009 · S/N T20608948N52678Land And Sea Aviation Alaska LLC · Anchorage, AKBuilt 2026 · S/N 172S13556N5267RCastlegate Corp · Monee, ILFirst renewal noticeBuilt 2002 · S/N 172S9180N5267YCkb Management LLC · Fayetteville, ARBuilt 2002 · S/N 172S9181N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161N5269NHigh Maintenance Inc · San Luis Obispo, CABuilt 2002 · S/N 172S9184N526BLWarren Flying Club Inc · Troy, MIBuilt 1998 · S/N 18280132N526EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13524N526ERLong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 172S9110N526LKKenzy 2022 LLC · Castle Rock, COBuilt 2022 · S/N 172S12923N526MEMike Whiskey Echo LLC · Camden, DEBuilt 2025 · S/N T18209168N526NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11063N5270GLewis University · Romeoville, ILBuilt 2009 · S/N 172S11003N52712Macmillan Elizabeth A · Franklin, MABuilt 2002 · S/N 172S9192N52715Echo Sierra 54 LLC · Hagerstown, MDBuilt 2002 · S/N T18208174N5271BTexas Department Of Public Safety · Austin, TXBuilt 2009 · S/N T20608952N5271FUnverfehrt David C · Ocala, FLBuilt 2009 · S/N T18208983N5272NMaddie LLC · Hinton, WVBuilt 2009 · S/N 172S10999N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162N5273UKatola LLC · Anaheim, CABuilt 2002 · S/N 172S9193N5274VH & R Aviation LLC · West Linn, ORBuilt 2009 · S/N 172S11005N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165N5275CRamaswamy Ashok · Clearwater Beach, FLBuilt 2009 · S/N T18208988N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938N52766Krobkrua Tio LLC · Snowflake, AZBuilt 2003 · S/N T20608398N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010N5276YPadlock Ranch Co · Ranchester, WYBuilt 2002 · S/N T18208176N5277LM2c2 Air LLC · Carlisle, PAS/N T20608399N52794Hawk Flyer 794 LLC · San Bruno, CABuilt 2002 · S/N 172S9211
Back to AD 2003-24-13