AD 2000-25-02 R1

Registered aircraft · 7,563

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.

N83975Driskill Lincoln · Devils Tower, WYS/N 7AC-2661N83976Whittington John H Jr · Rowland, NCBuilt 1946 · S/N 7AC-2662N83981H J Champion LLC · New Windsor, NYS/N 7AC2667N83982Clark William · Easton, MOBuilt 1946 · S/N 7AC-2668N83984White Paul M · Elizaville, NYBuilt 1946 · S/N 7AC-2670N83987Betzoldt Dan A · Tecumseh, MIBuilt 1946 · S/N 7AC-2673N83989Bentley John R · Bend, ORS/N 7DC-2675N83991Davis James C · Modesto, CABuilt 1946 · S/N 7AC-2677N83992Mandala Michael L · Chowchilla, CABuilt 1946 · S/N 7AC-2678N83994Rausch John C · Upland, CAS/N 7AC-2681N83995Dugger Timothy E · Anderson, AKBuilt 1946 · S/N 7AC2682N83996Keisler Homer L · Lexington, SCBuilt 1946 · S/N 7AC-2683N83997Fuentes Hansen B · Louisville, KYBuilt 1946 · S/N 7AC2684N83DHHansen Douglas M · Garden City, SDBuilt 1997 · S/N 786-96N84002Registered aircraftBuilt 1946 · S/N 7AC-2690N84003Shiner Stephen M · Marshfield, WIBuilt 1946 · S/N 7AC-2691N84004Swenson Leroy D · Le Sueur, MNBuilt 1946 · S/N 7AC-2692N84006Mueller David C · Fremont, NEBuilt 1976 · S/N 7AC-2694N84012Berghoff Lewis · Selmer, TNBuilt 1946 · S/N 7AC-2699N84016Plane Trail LLC · Mccook, NEBuilt 1946 · S/N 7AC-2703N84018Johnson Bennett · Everett, WABuilt 1946 · S/N 7AC-2705N84020Baker Robert · Dorr, MIBuilt 1946 · S/N 7AC-2707N84021Hart Timothy S · Apison, TNBuilt 1946 · S/N 7AC-2708N84025Griesman Scott W · Sandy Valley, NVBuilt 1946 · S/N 7AC-2712N84028Kranz Michael J · Castlewood, SDS/N 7AC-2715N84029Chase Michael D · Sonora, CABuilt 1946 · S/N 7AC-2716N84030Lester Gordon W · Corpus Christi, TXBuilt 1946 · S/N 7AC-2717N84031Hamilton James S · Decker, MTBuilt 1946 · S/N 7AC-2718N84032Eide Donald B Trustee · Webster, MNBuilt 1946 · S/N 7AC-2719N84033Schmitt Zachary J · Nordman, IDBuilt 1946 · S/N 7AC-2720N84035Howell John R · Bertram, TXBuilt 1946 · S/N 7AC-2722N84046Bowman Stephen Lee · Palm Bay, FLBuilt 1946 · S/N 7AC-2733N84049Link James L · Raleigh, NCBuilt 1946 · S/N 7AC2736N84053Mandala Mike L · Chowchilla, CABuilt 1946 · S/N 7AC-2740N84056Registration Pending · Carmi, ILRegistration pendingBuilt 1946 · S/N 7AC-2743N84059Lsa Flight LLC · Louisville, KYBuilt 1946 · S/N 7AC-2746N84067Srofe Danny D Jr · West Portsmouth, OHBuilt 1946 · S/N 7AC-2754N84069Kim Jonathan · Abilene, TXBuilt 1946 · S/N 7AC-2756N84070Kraft Ag Aviation Inc · Mapleton, NDBuilt 1946 · S/N 7AC-2757N84074Abbe Thomas E · Wasilla, AKBuilt 1946 · S/N 7AC-2761N84075Normark Nancy · Weirsdale, FLBuilt 1946 · S/N 7AC-2762N84080Thomas Richard E · Lafayette, TNS/N 7AC-2767N84081Pedri Michial A · Cool Ridge, WVBuilt 1946 · S/N 7AC-2768N84083Cottrell Alan L · Toano, VABuilt 1946 · S/N 7AC-2770N84084Airknocker LLC · Vidalia, LABuilt 1946 · S/N 7AC-2771N84091Nantz William G · Raleigh, NCBuilt 1946 · S/N 7AC-2778N84096Walls Sales LLC · Poplar Bluff, MOBuilt 1946 · S/N 7AC-2783N840WAOwatonna Warrior LLC · Owatonna, MNBuilt 2009 · S/N 1091-2009N84100270 Aero LLC · Fulton, KYBuilt 1946 · S/N 7AC-2787N84111Boggs Aerospace LLC · Keyser, WVBuilt 1946 · S/N 7AC-2797
Back to AD 2000-25-02 R1