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.

N6741DPerformance Aircraft C LLC · Litchfield Park, AZBuilt 1983 · S/N TH-1395N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6742NCrazy Mountains Aviation LLC · Columbus, GAS/N TH-1140N6743CRocket Ems Inc · Santa Clara, CABuilt 1980 · S/N TJ-269N6745MPerkins Communication LLC · Northport, ALBuilt 1980 · S/N TH-1124N6747TYesco Administration LLC · Salt Lake City, UTBuilt 1984 · S/N TH-1403N6747VGap Mountain Development LLC · Jaffrey, NHBuilt 1980 · S/N TC-2316N6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYBuilt 1980 · S/N TK-120N6748YGalvin Richard · Laytonsville, MDBuilt 1980 · S/N TC-2317N6749XSchindele Micheal D · Tolna, NDBuilt 1961 · S/N 310-0049N674CCTrn Aviation LLC · Mcallen, TXS/N 414-0453N674PCLegal Wings I LLC · Overland Park, KSBuilt 1978 · S/N 340A0544N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079N6752XIyer Vijay · Mammoth Lakes, CABuilt 1980 · S/N TJ-276N6752ZVector USA LLC · Olive Branch, MSBuilt 1981 · S/N ME-340N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083N6758XAc Green LLC · Athens, OHBuilt 1980 · S/N TK-134N675JZMercer Fraser Co · Brookings, ORBuilt 2015 · S/N 20800570N675RVb Flying LLC · Cornelius, NCBuilt 1981 · S/N 414A0634N675SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20800675N6760AFreestone William W · Saint Augustine, FLS/N 27-7954086N67664Hukill Ryan R · Eagle Point, ORS/N 340A1534N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182N676GGuest Air LLC · Plains, GABuilt 1980 · S/N TH-1179N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122N676TGRick Aviation Inc · Newport News, VABuilt 1964 · S/N TC-676N6772XKallhoff Mark R DBA · Canby, MNBuilt 1961 · S/N 310-0072N6776APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954088N6777MPineiro Enrique · Miami, FLBuilt 1961 · S/N 310-0073N6777YPlaquemines Parish Government · Belle Chasse, LABuilt 1968 · S/N 27-4109N6779XSmith Peter I Trustee · Ocala, FLBuilt 1961 · S/N 310-0079N677CMWiemer Walter T · Cornwall, NYS/N TC-1206N677HCWashburn Wall Systems LLC · Cedar Rapids, IAS/N 421B0387N6780XN6780x LLC · Duluth, MNBuilt 1961 · S/N 310-0080N6784XSjc Vii LLC · Lawrence, KSBuilt 1961 · S/N 310-0084N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122N6787XTennis Gayland L · Bath, MIBuilt 1961 · S/N 310-0087N6787YCoachron Investments · Grosse Ile, MIBuilt 1969 · S/N 27-4124N678CWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 34-7870236N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876N678HDawson Aircraft Inc · Clinton, ARBuilt 1981 · S/N 414A0678N678JInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N TH821N678JSGolden Pegasus LLC · Hughson, CABuilt 1978 · S/N 414A0090N678MG2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2014 · S/N 3449492N6791XEve Scott G · Odessa, TXBuilt 1961 · S/N 310-0091N6793YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4131N6796VBar Wr Air Services LLC · Dallas, TXS/N 421C1045N67971Trophy Holding LLC · Ocoee, FLBuilt 1984 · S/N TH-1408N6797XJ & W Air LLC · Wilmington, DEBuilt 1961 · S/N 310-0097
Back to AD 2004-25-16 R1