OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,561

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:2000-25-02-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:2000-25-02-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.

N2737ZBrown Joseph Earl · Lawrenceburg, INBuilt 1978 · S/N 1233-78N2738EWilliams Aviation Inc · Chapmansboro, TNBuilt 1946 · S/N 7AC-6319N2739EManning Mark D · Wrenshall, MNS/N 7AC-6320N2745EKingdom Air Corps · Sutton, AKBuilt 1946 · S/N 7AC-6326N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78N2747EErickson Rodney L · Rutland, NDBuilt 1946 · S/N 7AC-6304N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143N2748ETorok William II · Cedarville, OHS/N 7AC-6328N2748GNoe Aviation LLC · Vinton, IAS/N 152N274ACWelch Thomas R · Modesto, CABuilt 2007 · S/N 1014-2007N2750EStuart M Davis Inc · Rice, WAS/N 7AC6331N2751GSpears Patricia C · Longmont, COBuilt 1967 · S/N 56N2752EDorman Richard E · Mesa, WABuilt 1946 · S/N 7AC-6333N2753GJans Dream Machine LLC · Lewes, DES/N 66N2755EStephenson Gary E · Philip, SDBuilt 1946 · S/N 7AC-6336N2759ARichards Thomas D · Saint Jo, TXBuilt 1946 · S/N 7AC-6389N2759ELindholm Donald W · Morning Sun, IABuilt 1946 · S/N 7AC-6339N275ACTsutsumi Erika E · Boston, MABuilt 1998 · S/N 1372-98N275CWLunde Craig W · Fort Shaw, MTBuilt 1946 · S/N 1744N275MAFranzoy Steve · Salem, NMS/N 1014-2006N2762EMaynard Brent N · Hurricane, WVBuilt 1946 · S/N 7AC-6345N2763EPowers Gene Carroll · Kennedale, TXBuilt 1946 · S/N 7AC-6346N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459N2767EMann Thomas A · Ford, WABuilt 1946 · S/N 7AC-6350N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76N2768EPadgett Kenneth W · Cortland, OHBuilt 1946 · S/N 7DC-6351N276RSchwam Julie R · Hayden, IDS/N 713-93N2771EBenton James A · Enterprise, ALBuilt 1946 · S/N 7AC-6355N2772GSchultz Jason G · Crowley, LABuilt 1967 · S/N 460N2773EMorgan Carl D · Wheeling, MOBuilt 1946 · S/N 7AC-6357N2774EWeiler Mark L · Saint Peters, MOBuilt 1946 · S/N 7AC-6358N2777CSteiner Richard D · Butler, PABuilt 1956 · S/N 7BCM-119N2778ZLarson Kris Kendrick · Fullerton, CABuilt 1978 · S/N 370-78N277MANickell Paul D · Milo, IABuilt 2003 · S/N 1354-2003N277UHaase David A · Appleton, WIBuilt 1946 · S/N 7AC-1622N2780EAdams Fertilizer Inc · Senath, MOBuilt 1946 · S/N 7AC-6363N2782EBender Marlo B · Chandler, AZBuilt 1946 · S/N 7AC-6365N2783EJohnson Lucas G · Pleasant Lake, MIBuilt 1946 · S/N 7AC-6366N2786EVotava Paul A · Mcintosh, MNBuilt 1946 · S/N 7AC-6369N2787EMonteith Andrew W · Lebanon, PABuilt 1946 · S/N 7AC-6370N2788EStout Brian · San Martin, CABuilt 1946 · S/N 7AC-6371N2789EMckendry Scott P · Sanford, NCS/N 7AC-6372N278ACLetourneau University · Longview, TXBuilt 2001 · S/N 1385-2001N278GMAmerican Champion Aircraft Corp · Rochester, WIS/N 1239-2027N2793EGoertz Ronald L · Livingston, TXBuilt 1946 · S/N 7AC-6376N2794EHardy Richard C · Lakeland, FLBuilt 1946 · S/N 7AC-6377N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018N27TXDavis David A · Weatherford, TXBuilt 1969 · S/N 195
Back to AD 2000-25-02 R1