OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
  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.

N58MDLicandro Rudolph · Prospect, KYBuilt 1979 · S/N TJ-248N58MFTurk Mike F · Pinehurst, TXBuilt 1972 · S/N TH-279N58MHA Pro LLC · Hernando, MSBuilt 1995 · S/N TH-1752N58NDNorth Dallas Aviation Inc · Addison, TXBuilt 1999 · S/N TH-1906N58PHangar Seven LLC · Penn Yan, NYBuilt 1980 · S/N TJ-303N58PADwt Air LLC · Lakeland, FLBuilt 1981 · S/N TJ-348N58PBDirect Flight LLC · Kitty Hawk, NCBuilt 1983 · S/N TH-1379N58PCGrooms David C · Gallatin, TNBuilt 1977 · S/N TJ-101N58PDFoley Jeffrey William · Scappoose, ORBuilt 1976 · S/N TJ-86N58PECenice LLC · Eagle, COBuilt 1982 · S/N TJ-435N58PFVeilleux Jean-Christophe · Escondido, CAS/N TH-888N58PGTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1967 · S/N 27-3772N58PPWeaver Aviation LLC · Mount Pleasant, SCS/N TC-1762.N58PRQuinlan John H · Claxton, GABuilt 1978 · S/N TJ-149N58PWPapa Leasing LLC · Helena, MTBuilt 1974 · S/N TH-459N58PZMiller Paul David · Dallas, TXBuilt 1981 · S/N TJ-360N58QPHk Ventures LLC · Paynesville, MNBuilt 1990 · S/N TH-1612N58RAGibbs Ron · Parker, AZBuilt 1975 · S/N TJ-14N58RHHubbard Robert R Dds · Harrison, ARBuilt 1973 · S/N TH-362N58RJLogan Flyers LLC · Logan, OHBuilt 1968 · S/N 27-3971N58SLHome Air Inc · Gainesville, GABuilt 1980 · S/N TH-1121N58SZRising Wings Aviation LLC · Walnut Creek, CAS/N TH-2090N58TBTaylor Scott · Bg Bnd Ntl Pk, TXS/N TJ-113N58TCN58tc LLC · Gibsonton, FLBuilt 1984 · S/N TJ-455N58TDEaston Douglas J · Sandpoint, IDBuilt 1982 · S/N TJ-411N58TEGtk Services LLC · Carbondale, ILBuilt 1980 · S/N TJ-326N58TFFlying Matters LLC · Cedarburg, WIBuilt 1980 · S/N TJ-292N58TKTwa Partners LLC · Billings, MTBuilt 1979 · S/N TK-107N58TPDiamond Aircraft Corporation · Miami, FLBuilt 1977 · S/N TH-843N58TWHouck Christopher · Cary, NCBuilt 1973 · S/N TH-369N58UATunica Air Inc · Tunica, MSBuilt 1980 · S/N TH-1194N58VBBeckman Donald A · Rostraver Township, PABuilt 1980 · S/N TJ-260N58WFHohlrieder Automotive Co · Yorktown, VABuilt 1977 · S/N TH-831N58WGN58wg LLC · Shreveport, LABuilt 1972 · S/N TH-208N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705N58ZZDestination Marketing Group LLC · Sedona, AZBuilt 1983 · S/N TJ-432N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N590NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496269N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N5911LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496102N5911MYataco Enrique · Dothan, ALS/N 310P0211N5911YDileo Steven J · Gallatin, TNBuilt 1965 · S/N 27-3067N5913MWallace Larry Wayne · Millsap, TXBuilt 1969 · S/N 310P0213N5914MBogie Aviation LLC · Newton, NJBuilt 1969 · S/N 310P0214N591ADSome Amigos LLC · Spring, TXBuilt 1964 · S/N TC-647N591NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496633N591TASnappys Rotor & Wing LLC · Klamath Falls, ORBuilt 1981 · S/N 34-8233076N5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSBuilt 1965 · S/N 27-3077N5922YUltimate Air Parts LLC · Strasburg, VABuilt 1965 · S/N 27-3080N5925MDickerson Stephen R · Frisco, TXBuilt 1969 · S/N 310P0225
Back to AD 2004-25-16 R1