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.

N171RACirrus Aviation Inc · Sarasota, FLBuilt 1999 · S/N 172S8237N171SCAlpha Charlie Aviation LLC · Oregon City, ORS/N 172S12589N171SPState Of Iowa - Iowa State Patrol · Des Moines, IABuilt 2007 · S/N 18281977N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703N1720A1720a LLC · Bethany, OKBuilt 2022 · S/N 172S12892N17223Tao Farm LLC · Ririe, IDBuilt 2007 · S/N 172S10635N1723ARegistration Pending · Kennesaw, GARegistration pendingBuilt 2026 · S/N 172S13507N1724LAzul Assets LLC · Santa Fe, NMBuilt 2007 · S/N 18282018N1724UChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10443N1725LMeyer Frank · Williamsburg, VABuilt 2007 · S/N 18282019N1726TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12052N17274University Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280353N1727LTexas Department Of Public Safety · Austin, TXFirst renewal noticeBuilt 2007 · S/N T20608791N1728LCaldwell Clifton M · Sterling City, TXBuilt 2007 · S/N T20608776N17297Barrier William · Pensacola, FLBuilt 1997 · S/N 17280140N172ALRegistered aircraftBuilt 2023 · S/N 172S12931N172AVFlight Training Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11203N172BFLewis University · Romeoville, ILBuilt 1997 · S/N 17280175N172BWThompson Joe Dean · Montgomery, TXBuilt 2005 · S/N 172S9813N172CNGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2020 · S/N 172S12458N172CYAnson Air LLC · Sugar Land, TXBuilt 2001 · S/N 172S8729N172DRCunningham Darius L · Sterling, VABuilt 1997 · S/N 17280272N172EFNorth Shore Aero Club Inc · Beverly, MABuilt 2000 · S/N 17280876N172ELRegistered aircraftBuilt 2023 · S/N 172S12930N172FANorthwestern Michigan College · Traverse City, MIBuilt 2012 · S/N 172S11167N172FKBig Heart Arts LLC · Grass Valley, CABuilt 2013 · S/N 172S11249N172FNSkyhawk 172 LLC · Eugene, ORS/N 17280004N172FRHetrick Air Services Inc · Lawrence, KSBuilt 2008 · S/N 172S10728N172GHNebel & Son Aircraft Leasing Inc · Jacksonville, FLBuilt 1997 · S/N 17280192N172GWTechau Troy E · Kissimmee, FLBuilt 1999 · S/N 172S8289N172HGLewis University · Romeoville, ILBuilt 2011 · S/N 172S11139N172HPSpinnaker Aviation LLC · Conroe, TXBuilt 1997 · S/N 17280274N172HWLowther Fred · Corvallis, ORBuilt 2000 · S/N 172S8407N172HXElevation Air Capital LLC · Beloit, WIBuilt 2002 · S/N 172S9263N172JEBachman Aviation Inc · Winter Haven, FLBuilt 1997 · S/N 17280289N172JPWnc Aviation LLC · Arden, NCBuilt 1998 · S/N 17280560N172JVLima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9420N172KKIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280574N172KSPlanelogic LLC · St George, UTBuilt 2003 · S/N 172S9481N172LKPinnacle Aviation Services Inc · Encinitas, CABuilt 1997 · S/N 17280129N172MTTrede 2020 C172 LLC · Aurora, ORBuilt 2020 · S/N 172S12518N172RAFjiro Aviation N172ra LLC · Vancouver, WABuilt 2005 · S/N 172S9919N172RCWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280204N172RDTop Flight Aviation Inc · Corona, CABuilt 2005 · S/N 172S10045N172RHMaya Air Services LLC · Lee, NHBuilt 2003 · S/N 172S9432N172RKEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8082N172RVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2008 · S/N 172S10776N172SEIcebox Express LLC · Intl Falls, MNBuilt 2021 · S/N 172S12632N172SJCommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280291N172STTextron Aviation Inc · Wichita, KSS/N 172S13635
Back to AD 2003-24-13