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.

N3544GMid-Island Air Service Inc · Ronkonkoma, NYS/N 17281072N3544WRapid Fleet I LLC · Carmel, INBuilt 2001 · S/N 172S8904N3544ZSky Chiefs Aviation LLC · Gainesville, FLS/N 172S8999N3545JBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281023N3546HOdonnell John Merritt · Kennebunkport, MEBuilt 2001 · S/N 18281017N3546QRahe John S · Marana, AZS/N 172S8889N3547FEastern Kentucky University · Richmond, KYS/N 172S8887N3547HCali Air LLC · San Ramon, CAS/N 172S8886N3547LSky Brothers LLC · Boulder, COS/N 172S8884N3547RL & R Flyers LLC · Bradenton, FLS/N 17281066N3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N T20608322N3548AKunard Kevin L · Pinedale, WYS/N T18208072N3548MSpenser Air LLC · Starkville, MSS/N 18281019N3548SSunny Skies Aviators LLC · Vernal, UTS/N 18281018N3548VT-28 LLC · Salem, ORBuilt 2001 · S/N 172S8892N35491L&W Leasing LLC · Smyrna, TNS/N 17281069N3549HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N T18208064N354CPCivil Air Patrol · Montgomery, ALBuilt 2005 · S/N 18281506N354CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10942N354ESN354es LLC · Stuart, FLBuilt 1997 · S/N 17280047N354STelfer William D · Perkasie, PABuilt 1999 · S/N 18280650N354TAChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9354N35502Sky Mates Inc · Wilmington, DES/N 172S8895N3550TTotal Flight Aircraft Leasing LLC · Apex, NCS/N 172S8893N3552CAtlas Aviation Tampa Inc · Tampa, FLBuilt 2001 · S/N 172S8900N3552DBarwick H Brooks III · Clinton, NCBuilt 2001 · S/N 18281020N3552L4wblue LLC · Waccabuc, NYBuilt 2001 · S/N 18281021N3552QRegistered aircraftBuilt 2001 · S/N 18281022N3553DM&R Aircraft LLC · Wilmington, DES/N T18208090N3554EZin Services LLC · Dove, DEBuilt 2001 · S/N 172S8948N3554PCrimson Enterprises LLC · Wilmington, NCS/N 172S8955N3555LHillsboro Aero Academy LLC · Hillsboro, ORS/N 172S8865N3556VWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281009N3556ZJohnson Paul A Trustee · Bloomfield Hills, MIBuilt 2001 · S/N T18208060N35578Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8867N3557EWinged Bullies LLC · Spicewood, TXS/N 17281057N35583Confluence Systems Consulting Inc · San Jose, CAS/N 172S8872N3559EGreater Flint Pilots Association Inc · Flushing, MIS/N 18281010N3559RWest Indies Aviation Corp Trustee · Wilmington, DEBuilt 2001 · S/N 18281011N355CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281507N355CWLevare Aviation Inc · Hillsborough, NJBuilt 2008 · S/N T20608817N355GMTextron Aviation Inc · Wichita, KSS/N 18283367N355GWValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 172S9355N355MEBode Aviation Inc · Albuquerque, NMBuilt 2000 · S/N 172S8590N355SRMoonglow Aviation LLC · Dover, DEBuilt 2004 · S/N T20608458N3560GVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208063N3560XCarey Brad Eugene · Grapeview, WABuilt 2001 · S/N 18280941N3566ASun City Aviation LLC · Davie, FLBuilt 1997 · S/N 17280021N356BFRegistered aircraftBuilt 2004 · S/N 18281392N356CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281508
Back to AD 2003-24-13