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.

N548SPMinter Barry · Rockport, MOBuilt 2000 · S/N 172S8401N5491JChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10395N549ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281598N549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedS/N 20608052N549BJN549bj LLC · Fayetteville, ARBuilt 2022 · S/N T20609688N549EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13547N549MCBulldog Air LLC · Becker, MSBuilt 2000 · S/N T20608168N549NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11051N54EMAvirone Ltd · Monsey, NYBuilt 1998 · S/N 18280399N54JASan Carlos Flight Center Inc · San Carlos, CABuilt 1998 · S/N 17280607N54KPScheuers Alan · Murfreesboro, TNBuilt 2005 · S/N 18281542N54LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12062N54ZAWestside Gas Inc · Tucson, AZBuilt 2012 · S/N T20609082N550CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N T20609617N550ERCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 172S10531N550LAOscar Tango LLC · Mesa, AZBuilt 2017 · S/N 172S12045N550NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10992N5518GChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11391N5518WChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11390N551ERSunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10548N551ESNimno 551es LLC · Pompano Beach, FLBuilt 2005 · S/N 172S9902N551HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2001 · S/N T20608286N551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeBuilt 2008 · S/N 172S10858N551SPIllinois State Police · Springfield, ILBuilt 2024 · S/N T20609766N5520NChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11400N5520SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11399N5520UChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11398N5520XUS Aviation Training Solutions Inc · Titusville, FLBuilt 2014 · S/N 172S11405N55218Christiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11424N5521QEckmann Sheri L · Santa Barbara, CABuilt 2014 · S/N 172S11422N5521SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11421N5522A5522a LLC · Bethany, OKBuilt 2014 · S/N 172S11423N5522SAmeriflyers Of Texas Inc · Addison, TXBuilt 2014 · S/N 172S11430N5522XChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11429N55231Golf November Aero LLC · Sunnyvale, CABuilt 2014 · S/N 172S11414N55234Alien Invaders LLC · Medina, WABuilt 2014 · S/N 172S11415N5523QDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11412N5523VDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11413N5524CStewart Kyle · Santa Barbara, CABuilt 2013 · S/N T20609116N5525RJwh Dalton Holdings LLC · Brentwood, TNBuilt 2014 · S/N T20609141N5526JBravo Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11484N55285Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11511N55292Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11515N55294Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11516N55296Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11517N55297Goodhue LLC · Myrtle Beach, SCBuilt 2014 · S/N 172S11518N5529ZAerosim Academy Inc · Sanford, FLS/N 172S11514N552MNMtc Air LLC · Blue Ridge, GABuilt 2005 · S/N 18281588N552NDOdegaard Wings Inc · Kindred, NDS/N 172S10859N552SPEngineers Flying Club Inc · Bethany, OKBuilt 2000 · S/N 172S8404
Back to AD 2003-24-13