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.

N6627YMiller Jay M DBA · Grantsville, MDBuilt 1969 · S/N 27-4399N6628XAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-218N6628YAri Ben Aviator Inc · Ft Pierce, FLBuilt 1979 · S/N ME-219N662CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 318052014N6630AIndigo Associates Ltd · Las Vegas, NVBuilt 1978 · S/N 27-7954027N6631CD Porter Enterprises LLC · Dickinson, NDBuilt 1978 · S/N 414A0038N6632JSo Cal Leasing LLC · El Cajon, CABuilt 1980 · S/N ME-337N6632UFox Falley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-323N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239N6633TC C I C Aircraft Division One LLC · Kalispell, MTBuilt 1977 · S/N 421C-0277N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266N6639KXp Skyhawk LLC · San Luis, AZBuilt 1979 · S/N TH-1049N663GGNt Miller LLC · Winchester, KYBuilt 1975 · S/N 33701634N663JMCh Aviation LLC · Wilmington, DES/N TH-2121N6640CGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0044N6643EReynolds Ronnie · White Hall, ARBuilt 1979 · S/N TJ-215N6644KRrc Upper Freehold LLC · Farmingdale, NJS/N TH-2076N6644QLomakin Anatol · Lincoln Park, NJBuilt 1974 · S/N 414-0543N6644YN6644y LLC · Philomath, ORBuilt 1968 · S/N 27-3958N6645AAlmost There Air LLC · Daytona Beach, FLBuilt 1978 · S/N 27-7954029N6645YDietl Manfred · Naples, FLBuilt 1979 · S/N TC-2258N6646ZN1437a LLC · Delray Beach, FLBuilt 1981 · S/N TJ-203N6647YSkyway Inc · Wilmington, DEBuilt 1968 · S/N 27-3880N6648KWest Star Lands LLC · Seminole, TXBuilt 1979 · S/N TJ-204N6648WN6648w LLC · Wilmington, DES/N TC-2242N6649DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N TH-1041N664GBTcc Air Services Inc · Greenwich, CTS/N TC-2093N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467N66518Daly Stephen M · Oakland, FLBuilt 1979 · S/N TH-1044N6654YLewis Garry L · Livingston, LABuilt 1979 · S/N TH-1061N66568Trapp Aviation Ltd · Lebanon, OHS/N TK-105N6658SKgb58 Aviation LLC · Gibsonia, PAS/N TH-681N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222N6659YUhles Denny · Bakersfield, CABuilt 1968 · S/N 27-3974N665SCGold Star Beacon LLC · Sarasota, FLBuilt 1975 · S/N 340A0006N66619West Bend Air Inc · West Bend, WIBuilt 1979 · S/N TH-1070N6661YSchlosser David · Scottsdale, AZBuilt 1979 · S/N TH-1068N6662NRegistration Pending · Uvalde, TXRegistration pendingS/N TH-1073N66634Span Tech LLC · Glasgow, KYBuilt 1979 · S/N TC-2268N6664YSmooth Air Inc · Ocala, FLBuilt 1968 · S/N 27-3980N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227N6666XBlack Sheep Aviation LLC · Palm City, FLBuilt 1979 · S/N TH-1093N6669DMaster Designs LLC · Gilbert, AZBuilt 1979 · S/N TC-2271N6669XEdm-Van LLC · Maple Lake, MNBuilt 1979 · S/N TK-108
Back to AD 2004-25-16 R1