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.

N626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeS/N 421C0512N626DWWings Of Freedom LLC · Big Bear Lake, CABuilt 1969 · S/N 30-1799N626FMN626fm LLC · Brunswick, GABuilt 1979 · S/N 34-7970142N626HRegistered aircraftBuilt 1966 · S/N TC-980N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280N626JGEastern Stearman Inc Trustee · Leesburg, VAS/N 34-8133105N626MVMandj LLC · Denver, COS/N 34-8170074N626NRJones Robert D · Chestertown, MDBuilt 1970 · S/N 39-82N626SPJoye Robert M · Casa Grande, AZBuilt 1976 · S/N 27-7654094N626WAZarlenga And Seltzer Inc · Palmyra, PABuilt 1977 · S/N 34-7770303N62707Registration Pending · Piedmont, SCRegistration pendingBuilt 1976 · S/N 27-7654163N6271RAir Jag LLC · Garden City, KSBuilt 1982 · S/N TH-1331N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141N62745Pacific Fleet Aviation LLC · Rochester, NYS/N 27-7654193N62756Red State LLC · Daytona Beach, FLBuilt 1976 · S/N 27-7654202N62757Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7654203N6276FHubler Bruce F · Caldwell, IDS/N 337-0276N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460N6277QFly Me LLC · Sparta, TNBuilt 1973 · S/N 310Q0747N62787Williamsburg Air Service Inc · Kingstree, SCBuilt 1977 · S/N 27-7754024N627EMMinton Air LLC · Alexandria, VABuilt 2025 · S/N 20800716N627JKUlrich Sandy J · Haskell, OKBuilt 1966 · S/N 27-3223N627LBJk Air LLC · Tupelo, MSBuilt 1980 · S/N TC-2303N627MADestination Alaska Air Service LLC · Homer, AKBuilt 1975 · S/N 31-7512055N62801Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754032N62802Hannair LLC · Titusville, FLBuilt 1976 · S/N 27-7754033N62804Hill Adam John · Bethlehem, GAS/N 27-7754036N62807Neal Aircraft Inc · Slaton, TXBuilt 1976 · S/N 27-7754040N62808Wings Over Texas Holdings LLC · Denton, TXS/N 27-7754041N6280UBmk Farms · Fowler, KSBuilt 1982 · S/N TC-2439N6280YJ & S Of Wi LLC · Iola, WIBuilt 1966 · S/N 27-3527N62812Facer Insurance Agency Inc · Rantoul, ILFirst renewal noticeBuilt 1976 · S/N 27-7754044N62818Pollack Matthew · Falls Church, VABuilt 1976 · S/N 27-7754051N62823Mcmillan William K · Jamestown, NDS/N 27-7754057N62829Cor Yan · San Juan, PRS/N 27-7754035N62835Paperd Rex A · Fall City, WABuilt 1977 · S/N 27-7754067N62836Pacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754068N6283QOn Glidepath Properties LLC · Gilbert, AZBuilt 1972 · S/N 310Q0492N62840Emond Ronald L DBA · Nashua, NHBuilt 1977 · S/N 27-7754075N6284FMathews Wade A · Wichita Falls, TXS/N 337-0284N62869Brown Henry H · Prospect, KYBuilt 1976 · S/N 31-7652145N6288FAircraft Leasing And Service · Malabar, FLBuilt 1965 · S/N 337-0288N62898M & M Aircraft LLC · Cresson, TXS/N 317652157N62899Sf Health Solutions Inc · Homestead, FLBuilt 1976 · S/N 31-7652122N628AKBaron Partners LLC · Bessemer, ALS/N TH-1614N628AWHobart Aviation Inc · Akron, OHBuilt 1959 · S/N 23-1790N628HADigital Mapping Inc · Huntington Beach, CABuilt 1979 · S/N 31-7952085N628JWJuliet Whiskey LLC · Roanoke, VABuilt 1979 · S/N 414A0241N628MDClarkton Aviation III LLC · Clarkton, MOBuilt 1992 · S/N TH-1662N628QMcconville Aero LLC · Westminster, MDBuilt 1977 · S/N TC-2052
Back to AD 2004-25-16 R1