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.

N8567YJohnson Randy D · Becket, MAS/N 30-1715N8568RDavenport Gregory · Edmond, OKBuilt 1974 · S/N TH-525N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N8580RHabanero One Express Inc · Ann Arbor, MIBuilt 1974 · S/N TC-1771N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736N8585YGospel Ministeries International Inc · Mc Donald, TNBuilt 1968 · S/N 30-1738N8586YTrue Glenn C Jr · Phoenix, AZBuilt 1968 · S/N 30-1739N85881Zurbrigen Scott R · Punta Gorda, FLFirst renewal noticeBuilt 1968 · S/N 337-1009N85898Lewis Aviation Inc · Wilmington, DEBuilt 1968 · S/N 337-1016N8589RRegistered aircraftBuilt 1974 · S/N TC-1775N858LPFulps Aviation LLC · Winston Salem, NCBuilt 1978 · S/N TH-902N858MAMess Aero Inc · Grand Forks, NDBuilt 1997 · S/N 20800262N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257N858NCIal Corp · Lewes, DEBuilt 1977 · S/N TH-813N858PTj-128 LLC · Dover, DES/N TJ-128N858PBEast Ky Mobile Movers Inc · Pikeville, KYS/N TH-1541N858PRMelbourne Air Partners LLC · Indialantic, FLBuilt 1981 · S/N TH-1221N858TCH2 Transportation LLC · Macon, GABuilt 1979 · S/N TK-98N858WGreat Pond LLC · Bedford, MAS/N TH-2060N85901Hangar Nine Point Five LLC · Aztec, NMBuilt 1969 · S/N 337-1018N8590YNorthern Aviation LLC · Palmer, AKBuilt 1968 · S/N 30-1641N85918H P Aviation LLC · Mclean, VABuilt 1968 · S/N 337-1023N8593YNickajack North LLC · Ocala, FLS/N 30-1640N8595BGreene County Vocational School District · Xenia, OHS/N 27-7305127N8595YKor Reese W · Piedmont, SDBuilt 1967 · S/N 30-1624N85965Burn Gray P · North Stonington, CTBuilt 1968 · S/N 337-1037N8596RTjh Aviation · Greenville, TXBuilt 1974 · S/N TC-1780N8596YLeap Aviation Inc · Wilmington, DES/N 30-1623N8597YTaylor Douglas S · Fairfield, CABuilt 1967 · S/N 30-1653N8598YGulf Coast Aviation LLC · New Orleans, LABuilt 1967 · S/N 30-1607N85992Mildenburger Frederick E · Scottsburg, INBuilt 1969 · S/N 337-1051N859DMDavis Mark E · Pearland, TXS/N 421C0859N85AGLavergne Rusty P · Denham Springs, LAS/N 34-7970293N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435N85BGIsley Aviation Inc · Fort Myers, FLBuilt 1974 · S/N 310Q1068N85CMRuggles Don C · Texarkana, ARS/N TC-1092N85FS7353r Co Partnership · Pottstown, PABuilt 1974 · S/N TH-486N85KFreeman Edward J · Pittsboro, INBuilt 1975 · S/N 34-7670100N85KSCnet Aviation LLC · Lindale, TXBuilt 1978 · S/N 421C0525N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168N85RJTechnical Education Services Inc · Virginia Beach, VAS/N 27-7554127N85SRMccorkle Air LLC · Wilmington, DEBuilt 1974 · S/N 310Q0903N85VLBowers Jay · Farwell, TXBuilt 1967 · S/N 30-1509N85WLWillis Lease Finance Corp · Larkspur, CABuilt 1995 · S/N 20800245N8600YMontcalm Kevin L · Mansfield, LABuilt 1968 · S/N 30-1740N86020Yamnik Alexander E · Glencoe, MNBuilt 1969 · S/N 337-1054N8605KWadsworth & Wadsworth LLC · Morehead City, NCS/N 340A1241N8605YFudenberg Elevated Solutions LLC · Las Vegas, NVS/N 30-1745N86071Mccumber Peter W · Sorrento, FLBuilt 1969 · S/N 337-1065N8607YMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 30-1747
Back to AD 2004-25-16 R1