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.

N234RBMoyer Thomas L · Fayetteville, GABuilt 1976 · S/N TC-1950N234TGAvionicos Corp · Sarasota, FLS/N 34-8070234N234TLLanflisi Robert A · Fairfield, CAS/N 310Q0957N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022N23573Rolrice Family Limited Partnership · Tulsa, OKBuilt 1977 · S/N TC-2107N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587N235SMTriniair LLC · Warner Robins, GAS/N TH-926N23614Great American Jet Inc · Cincinnati, OHBuilt 1978 · S/N TC-2153N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666N2367PCrowley Steven J · Burlington, IABuilt 1981 · S/N TC-2367N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027N2369XChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 4496291N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805N236CFGriswold Joshua P · Los Angeles, CABuilt 1976 · S/N 34-7770091N236JEGunnels Farms Inc · Amarillo, TXS/N TC-2092N236MTPiper Aircraft Inc · Vero Beach, FLS/N 4496659N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116N237DCHinkle Airspray Inc · Cavalier, NDBuilt 1978 · S/N TJ-133N237MTPiper Aircraft Inc · Vero Beach, FLS/N 4496660N237PCBlue Water Solutions Inc · Peachtree City, GABuilt 1981 · S/N 31T-8166045N237SMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1976 · S/N 421C0237N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238N2397SState Of Wisconsin · Madison, WIBuilt 1967 · S/N 337-0697N239ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496038N239DGTabares Alain · Zephyrhills, FLBuilt 1968 · S/N TC-1187N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315N23ASRusso James F · Liberty, SCS/N 27-3094N23AUAverett University · Danville, VABuilt 2024 · S/N 4496570N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852N23ECDenver Aero Service Marine Inc · Wilmington, DEBuilt 1975 · S/N TC-1894N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415N23JDraco Flight School Inc · Chino, CAS/N 310I0108N23JCJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 348070121N23KMR H Phillips Trucking Co Inc · Shelby, OHS/N TH-2116N23MFTriay Services LLC · Metairie, LABuilt 1974 · S/N TC-1684N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28
Back to AD 2004-25-16 R1