OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,536

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.

N14379Bas Part Sales LLC · Greeley, COS/N 27-7304970N14386Blue Star Aviation Services LLC · Shippensburg, PABuilt 1972 · S/N 27-7304980N1438PTri Rotor Spray & Chemical · Ulysses, KSS/N 23-496N14394Pavco Inc · Gig Harbor, WABuilt 1972 · S/N 27-7304991N143ACPotcake Aviation LLC · Missoula, MTBuilt 1972 · S/N 27-7304989N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N143ELPremiere Aviation Inc · Concord, CABuilt 1979 · S/N 421C0646N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18N14401Berggren Ryan · Newton, NJBuilt 1967 · S/N 27-3722N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360N144JKLong Island Aviators LLC · Seaford, NYBuilt 1981 · S/N 34-8133010N144RCKilgore Shawn K · Argyle, TXBuilt 1974 · S/N TC-1750N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248N1452PSorenson Mark A · Senoia, GABuilt 1956 · S/N 23-515N1454PLansing Community College · Mason, MIBuilt 1956 · S/N 23-517N1455PMohamed Eman Z · Lubbock, TXBuilt 1956 · S/N 23-518N145DDemaray Russell N · Sedona, AZBuilt 1980 · S/N TC-2348N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507N1460PBas Part Sales LLC · Greeley, COS/N 23-523N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N1470BBerger Leo · Nampa, IDS/N 31-7512061N1474PMccormick Robert E · Selah, WAS/N 23-541N147BZSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 34-7870359N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102N14886Fat Aire Inc · Wilmington, DES/N 31T-7904036N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428N14934Csc Delaware Trust Co Owner Trustee · Wilmington, DEBuilt 1966 · S/N 27-3178N149AFTitan Group Inc · Tucson, AZS/N 421C-0098N149ARB-Cat Aviation LLC · Tulsa, OKBuilt 1983 · S/N 414A1006N149PCSubick Leonard · Spring City, PABuilt 1966 · S/N 27-3534N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060N14BRGobin Albert W · Crawfordsville, INS/N 310K0104
Back to AD 2004-25-16 R1