OpenAirDocs.org
AD 2003-24-13

Registered aircraft · 7,852

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.

N10004Etos Air LLC · New London, TXS/N T18208245N10033Thunderfighter LLC · Englewood, COS/N 172S9797N1004EUnison Air LLC · Palo Alto, CABuilt 2005 · S/N 172S9872N1006VLanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 172S9805N100CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T20609818N100GDElp LLC · Bedford, NHBuilt 2024 · S/N T18209152N100HX14 Aero Spaces LLC · Wilmington, DEBuilt 2008 · S/N 18282087N100KAConservation Flight LLC · Bronx, NYBuilt 2006 · S/N T20608602N100LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 172S13000N100LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2025 · S/N 172S13292N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075N100PMPegasus Air LLC · Louisville, KYBuilt 2004 · S/N 172S9599N100SUOhio State University · Columbus, OHS/N 172S11739N100TYFlyin M LLC · Middletown, DES/N 18281337N1012YNelson Susan P · Kirkland, WABuilt 2005 · S/N 18281543N1016NDrln Aviation LLC · Charlotte, NCBuilt 2005 · S/N 18281547N1016TPlane Fun Inc Tr Trustee · Snellville, GABuilt 2005 · S/N T18208371N101AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281181N101AMLehs Kent · Grimes, IABuilt 2005 · S/N T18208373N101DYDyess Investments LLC · Bassfield, MSBuilt 2007 · S/N T18208674N101GVWindward West Inc · Boise, IDBuilt 1998 · S/N 172S8021N101LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13119N101LPGranite Boarding LLC · Loomis, CABuilt 2004 · S/N T18208265N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709N101TFAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12710N101VBRegistered aircraftBuilt 1999 · S/N 18280438N101VKWings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 172S8211N101WLRegistration Pending · Wichita, KSRegistration pendingBuilt 2026 · S/N 172S13568N1021PYurok Tribe Construction Corp · Klamath, CABuilt 2005 · S/N T18208383N10262Davoli Third Family Limited Partnership · Lighthouse Point, FLBuilt 2006 · S/N T18208495N1028GCreed Brian H · Fredericksburg, VABuilt 2005 · S/N T18208381N1029TThomson Heath · Portola Valley, CABuilt 1999 · S/N T20608067N102AKRegistered aircraftBuilt 2006 · S/N 20608264N102BROtv Leasing · Bristow, VABuilt 2010 · S/N 18282264N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552N102HWDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281058N102JFAble Enterprise LLC · Tampa, FLBuilt 2006 · S/N T18208579N102KSKent State University · Stow, OHBuilt 2005 · S/N 172S10091N102LPWashington State Patrol · Olympia, WABuilt 2002 · S/N 18281121N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100N102MUTraining Planes LLC · Tampa, FLBuilt 1997 · S/N 17280285N102RSSuttle Richard T Jr · Austin, TXBuilt 2018 · S/N T20609551N1031XJj Byrne International Inc · Steamboat Springs, COS/N T18208268N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598N1036MMangon Aircraft Inc · Petaluma, CABuilt 2007 · S/N 172S10599N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663N103CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N T18209142N103ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13534
Back to AD 2003-24-13