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.

N7938YEai Aircraft LLC · Fairbury, NEBuilt 1966 · S/N 30-1029N793DSDale Aviation LLC · Wilmington, DES/N 33701376N793NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496408N7940YN7940y LLC · Eagle Harbor, MIBuilt 1966 · S/N 30-1032N7942YAtlantic Aero Marine Inc · Seaford, DEBuilt 1966 · S/N 30-1035N7945YLevel Up Aviation LLC · Newton, ALBuilt 1966 · S/N 30-1039N7948RRucinski Edward A · Climax, NCBuilt 1969 · S/N TC-1231N7949YReeve Howard E · Minot, NDBuilt 1966 · S/N 30-1045N794NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 4496434N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N7950YKool Wings Leasing LLC · Indianapolis, INBuilt 1966 · S/N 30-1046N7951QClifton James Dvid · Manchester, TNBuilt 1972 · S/N 310Q0672N7952YHufnagel Christopher R Trustee · Santa Fe, NMBuilt 1966 · S/N 30-1048N7953QGoodin David J · Yerington, NVBuilt 1972 · S/N 310Q0673N7954YBrausch Jon D · Huron, OHBuilt 1966 · S/N 30-1050N7955RAirjohn LLC · Cheyenne, WYBuilt 1969 · S/N TC-1234N7958DNewcomb Clint M · Benton, ARS/N TH-1019N7958YAl Banna Emad R · Huntingtown, MDBuilt 1966 · S/N 30-1054N795ABSilver Mar LLC · Key Biscayne, FLBuilt 1998 · S/N TH-1880N795YAirria Holdings LLC · BerlinBuilt 1979 · S/N ME-231N7960QHartwig Donald J · Riverside, CAS/N 310Q0679N7962YMay Anthony E · Stacyville, IABuilt 1966 · S/N 30-1060N7964KCentral Virginia Aviation Inc · Petersburg, VAS/N TC-685N7966YAlbano Alan T · Elbert, COS/N 30-1064N7967YDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 30-1065N7968RSierra View Aviation LLC · Verdi, NVBuilt 1969 · S/N TC-1237N7968YMustang Aeronautics LLC · Chandler, AZS/N 30-1066N796AATechnical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 27-7854036N796NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 4496435N7971YRegistration Pending · Collierville, TNRegistration pendingS/N 30-1070N7972QJett Aviation LLC · Success, ARS/N 310Q0681N7974YHughes Frank H · Hackberry, LABuilt 1966 · S/N 30-1073N7977YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1076N7978RTomme John Paul · Arlington, TXBuilt 1969 · S/N TC-1236N7978YBurnett Philip B · Lamar, ARBuilt 1966 · S/N 30-1077N7979KTdiation Flights LLC · Madison, ALBuilt 1964 · S/N TC-689N797MTJib Inc · Groton, CTBuilt 1978 · S/N 34-7870433N797NDUniversity Of North Dakota · Grand Forks, NDS/N 4496504N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439N7980YCherry Michael A · Winchester, ILBuilt 1966 · S/N 30-1080N7983YMclaughlin Scott A · Defiance, IABuilt 1966 · S/N 30-1085N7986YRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1966 · S/N 30-1089N7988YLevel Up Aviation LLC · Dothan, ALBuilt 1966 · S/N 30-1092N798NDYale Companies LLC · Fishers, INBuilt 2018 · S/N 4496436N7997QSilva Robert L · Bakersfield, CABuilt 1972 · S/N 310Q0685N7997YN7997y Inc · Miami, FLBuilt 1966 · S/N 30-1102N7998RSolberg Kevin L · West Fargo, NDBuilt 1969 · S/N TC-1241N7998YAirjohn LLC · Cheyenne, WYBuilt 1966 · S/N 30-1103N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657
Back to AD 2004-25-16 R1