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.

N51KAA & L Farm Services Inc · Helena, ARBuilt 1977 · S/N TC-2099N51KMBaker Leasing LLC · Kotzebue, AKBuilt 1973 · S/N 31-7305009N51MTTrantham Joey L · Panama City, FLBuilt 1985 · S/N TH-1485N51QZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 421C1237N51VBPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496616N51WMMacair Aviation LLC · Xenia, OHS/N 337-1140N5206YHart Lewis W DBA · Rexburg, IDBuilt 1962 · S/N 27-2254N520ABGolden Eagle Transportation LLC · Lafayette, LABuilt 1979 · S/N 421C0690N520AZSaydun LLC · Richardson, TXBuilt 1966 · S/N 27-3424N520LLMesoamerica Aviation Corp · Wilmington, DEBuilt 2002 · S/N TH-2052N520MSH2 Link Co · Chino, CABuilt 2006 · S/N 4496230N5213THess Garrett J · Fullerton, CABuilt 1972 · S/N 34-7250222N5213YFlying High Again LLC · Mount Juliet, TNBuilt 1962 · S/N 27-2261N5216YGv Air Inc · Medford, ORBuilt 1962 · S/N 27-2264N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067N521JMJmcy Air LLC · Wilmington, DES/N 31T-8004040N521KBJuggyjet Airways LLC · Weehawken, NJBuilt 1978 · S/N 34-7870384N521PMJetset Airmotive Inc · Hialeah, FLBuilt 1977 · S/N 31T-7720048N521RMHeal Ray · Denton, TXBuilt 1977 · S/N 421C0335N521WSCmt Properties LLC · Laurel, MSBuilt 1997 · S/N TH-1836N5220YHart Robert D · The Villages, FLBuilt 1962 · S/N 27-2269N5221TPalmer Charles S · Hernando, MSBuilt 1976 · S/N TC-1995N5222TRcs Services LLC · California, MDBuilt 1975 · S/N 33701655N5226YSale Reported · Miami, FLSale reportedBuilt 1963 · S/N 27-2275N5227JSbs Partnership · Henderson, NVBuilt 1980 · S/N 340A1036N5228TWhytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250226N522CAC-140 Company LLC · Milton, FLBuilt 1971 · S/N 27-4711N522ESkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 27-2495N5236MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-21N5236YSvh Flying Operations LLC · Mooresville, NCBuilt 1963 · S/N 27-2289N523HCN523hc LLC · Pinecrest, FLBuilt 1972 · S/N P-200N523MBJones Roy F · Benson, AZBuilt 1965 · S/N 310J0044N523PDRulewiez Dennis G · Jackson, MIBuilt 1979 · S/N 31T-7904044N524AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 31T7920039N524CBTechnical Film Systems Inc · Camarillo, CABuilt 1991 · S/N TH-1630N524ERGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 31-8152132N524RTN524rt LLC · Greensboro, NCBuilt 1970 · S/N TH-123N52515Oscar Deuce LLC · Virginia Beach, VABuilt 1967 · S/N 337M0048N5252TRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1972 · S/N 34-7250232N5253ALet Industries LLC · Lewes, DES/N 27-7654058N5256JKamenz Donald R · Mocksville, NCBuilt 1977 · S/N 340A0403N525QSugai Kunio K · Van Nuys, CABuilt 1975 · S/N 34-7670089N525SFPrimrose LLC · Columbus, NEBuilt 1976 · S/N 421C0080N525SWKramme Scott R · Elmer, NJBuilt 1979 · S/N 31T-8020024N525TMVertivue LLC · Allentown, PABuilt 1997 · S/N TH-1832N525WARegistered aircraftBuilt 1979 · S/N 34-8070005N5261JAc67333 Inc · Wilmington, DEBuilt 1976 · S/N 414-0852N5264JBrowne Bryan C · Allen, TXBuilt 1976 · S/N 414-0854N5265JSouthern Machine And Steel Inc · Fort Myers, FLBuilt 1976 · S/N 414-0855N5268CH2 Link Co · Lewes, DEBuilt 2002 · S/N 3449262
Back to AD 2004-25-16 R1