OpenAirDocs.org
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.

N182PHVan Bortel Aircraft Inc · Arlington, TXS/N 18281031N182PJHarris William · Bullard, TXBuilt 1998 · S/N 18280270N182PMRg Aviation LLC · Fulton, MSBuilt 2004 · S/N 18281330N182PPPatch Patricia A Trustee · Titusville, FLBuilt 2005 · S/N T18208389N182QAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N T18208605N182RHFinnelly Patrick J · Hunts Point, WABuilt 2004 · S/N 18281429N182RRDont Be Nosy LLC · Fresno, CABuilt 2005 · S/N 18281675N182SJSmj Ventures LLC · North Dighton, MABuilt 2007 · S/N 18281890N182SKSteele David J Trustee · Fullerton, CABuilt 2023 · S/N 18283214N182SVSky-Vu Flyers Inc · Fishers, INBuilt 2001 · S/N 18280928N182TAJeppesen Employees Flying Assiciation Inc · Englewood, COS/N 18280062N182TCDasko LLC · Louisa, KYBuilt 2007 · S/N T18208748N182TRSalley George M · Advance, NCBuilt 1998 · S/N 18280160N182TSLynch Larry E · West Branch, IABuilt 2004 · S/N T18208237N182VBNemirsky Nicholas · Huntington Beach, CABuilt 1997 · S/N 18280025N182VMBergey-Shisler Joanna · Chalfont, PABuilt 2001 · S/N 18281005N182VPJobsight Delta Inc · Sugar Grove, ILBuilt 1998 · S/N 18280247N182VTStarbros Aviation LLC · Southlake, TXBuilt 2003 · S/N 18281215N182WGBurgett Dale · Lake Lure, NCBuilt 2000 · S/N 18280831N182WMZjt Aviation LLC · Vidalia, GAS/N 18280223N182WNTyson Stephen E · Marion, IABuilt 2001 · S/N T18208061N182XSCamp Chris M · Marshallville, OHBuilt 2000 · S/N 18280742N182YYForrest C Cranfill Construction Co · Shallotte, NCS/N 18280340N182YZSouthern Latitude LLC · Alabaster, ALBuilt 1998 · S/N 18280198N1834UWirth Rodney A · Greenwood, ARBuilt 2005 · S/N T20608546N1838EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12174N1839EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12175N183CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282342N183MERegistration Pending · Page, AZRegistration pendingBuilt 2000 · S/N 20608107N183MKRude Daniel · Leesburg, VAS/N T18208341N183NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11083N1842EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12176N184AFG & M Aircraft Inc · Wheat Ridge, COBuilt 2003 · S/N 17281184N184CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283259N184CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282174N184NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11085N184RDAfrican Parks Aviation Trustee · Cheyenne, WYBuilt 1999 · S/N 18280466N184SGNby Productions · Bristow, VABuilt 2015 · S/N T20609184N1859UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9927N185BKSfh Inc · Fargo, NDBuilt 2018 · S/N T20609555N185CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13042N185KPNg Research · Bristow, VABuilt 2015 · S/N T20609185N18691869 Leasing LLC · Aurora, ORBuilt 2008 · S/N T20608802N186CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13495N186CSFlying Rock Aero LLC · Sunnyvale, CABuilt 2011 · S/N 172S11087N186DTBell Michael · Cameron Park, CABuilt 2004 · S/N 18281442N186TABraden Health LLC · Greensboro, NCBuilt 2018 · S/N 18283030N18728Atlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 172S9929N187CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13102N187DBSummerwind Aviation LLC · Mooresville, NCBuilt 2000 · S/N 18280922
Back to AD 2003-24-13