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.

N5157JApogee Finance LLC · Fort Worth, TXBuilt 1975 · S/N 340-0547N5157YChristine Flight Inc · Denver, COBuilt 1962 · S/N 27-2196N515BTAir Safety Investigators LLC · Nokomis, FLS/N 340A1816N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022N515FVSlowmow Inc · Palestine, TXS/N 414-0410N515GAFramalin Leonard · Troy, MIBuilt 1981 · S/N 31T-8104050N515LGN515lg Holding Inc · Wilmington, DEBuilt 1975 · S/N 31-7652001N515RGDowney Paul J · Newington, NHS/N TH-2108N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169N515VVGolden Age N515vv LLC · Norwalk, IABuilt 2025 · S/N 4496620N5160JZemnickas William V · Metamora, MIS/N 340-0550N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5164MChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-50N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555N5166MSun City Aviation LLC · Davie, FLBuilt 1978 · S/N ME-46N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166N516NSCavorite Aviation LLC · Lehi, UTS/N 447995098N516SABaron Aircraft Corporation · Richmond, VABuilt 1969 · S/N TC-1268N5175JAycock Charles C · Midland, TXS/N 340A0010N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N517EASchafer Erich S · Fremont, MIBuilt 1975 · S/N 27-7554125N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104N517MRDgw Aviation LLC · Elverson, PAS/N TH-2012N517RHRoyce Aviation LLC · Greenville, MSBuilt 1965 · S/N 310J0101N517SLLegends Air LLC · Wilmington, DES/N 34-7970114N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5188YElliott William R · Reno, NVBuilt 1962 · S/N 27-2235N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518N518CMTreakle Robert W · Austin, TXFirst renewal noticeBuilt 1967 · S/N 30-1594N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433N518QLab Aviation Corp · Montville, NJBuilt 1967 · S/N TC-1038N518TJJohnson Travis · Wright City, MOBuilt 1972 · S/N TC-1436N518YPWs Aviation Group LLC · Washta, IABuilt 1980 · S/N TJ-265N5194MSunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N ME-17N519BGAir Transportation Alternatives LLC · Carmichael, CABuilt 1980 · S/N TC-2321N519CMCygnet Aerospace Corp · Los Osos, CAS/N TJ-56N519DJKessler Nicholas R · Central Point, ORBuilt 1977 · S/N TC-2030N519SCCrockett Ryan · Veradale, WAFirst renewal noticeBuilt 1979 · S/N 340A0720N51APConrad Alan B · Las Vegas, NVBuilt 1980 · S/N 340A0970N51CCCreekview Corporation · Orlando, FLBuilt 1978 · S/N TC-2131N51CXAerodata LLC · Ann Arbor, MIBuilt 1978 · S/N 340A0533N51DBSeneca Air LLC · Birmingham, ALFirst renewal noticeBuilt 1978 · S/N 34-7970042N51FDH2f2 LLC · Prairie Village, KSBuilt 1979 · S/N TH-1075N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412N51JNNaylor Aviation LLC · Scotch Grove, IABuilt 1978 · S/N 27-7854128
Back to AD 2004-25-16 R1