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.

N9171EHimebaugh Bryce K · Brighton, MIS/N 11AC-802N9171LBrolan Aviation LLC · Kansas City, MOBuilt 1970 · S/N 258-71N9172EStalter David J · Goshen, INBuilt 1946 · S/N 11AC-803N9174LHunt Daniel R · Hayward, CABuilt 1972 · S/N 31-72N9175EMueller Kenneth H · Roca, NEBuilt 1946 · S/N 11AC-808N9175LNeuroth Kurt V · Saint Charles, MOBuilt 1971 · S/N 32-72N9176LMunoz Eduardo J · Acworth, GABuilt 1971 · S/N 35-72N9177KBishop David · San Marcos, CAS/N 37-72N9178LClarke Paul W · Cape Girardeau, MOBuilt 1972 · S/N 5-72N917AXGast Matthew Adam · Weston, WIBuilt 2026 · S/N 1233-2026N9180LPoynter Everett B · Somerset, KYS/N 38-72N9181LBrown Samuel L · Flatonia, TXBuilt 1971 · S/N 39-72N9183EWhite Lynwood E · Deep Run, NCBuilt 1946 · S/N 11AC-816N9184EIsenga Steven R · Zeeland, MIS/N 11AC-818N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72N91854Sjostedt Brad D · Cordova, AKS/N 357-72N9185EMoulder Clayton · Cheboygan, MIS/N 11AC-819N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72N9186EVan Delinder Martin A · Fulton, NYBuilt 1946 · S/N 11AC-820N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72N9188LSodowsky Jim L · Ponca City, OKBuilt 1971 · S/N 814-72N9189LParker Jeffrey D · Chelsea, ALS/N 33-72N9190ELindblom Carl O · Saxon, WIBuilt 1946 · S/N 11AC-824N9190LWilliamson Will R III · Florence, SCS/N 44-72N9191LMeyer Gordon L · Knoxville, TNBuilt 1971 · S/N 815-72N9193EBalazs Marguerite · Devine, TXBuilt 1946 · S/N 11AC-827N9193LAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 817-72N9194LRussell Keith M · Ivoryton, CTBuilt 1971 · S/N 818-72N9195LStatewide Transportation LLC · Oklahoma City, OKBuilt 1971 · S/N 293-72N9196LRunyon Larry · Susanville, CABuilt 1971 · S/N 294-72N9197ESeat Time Enterprises LLC · Rushville, NEBuilt 1946 · S/N 11AC-831N9197LSchutze Curt K · Knoxville, TNBuilt 1971 · S/N 295-72N9198ERobinson Terry J · West Chester, PABuilt 1946 · S/N 11AC-832N9199EAmerican Aviation Heritage Foundation Inc · Blaine, MNBuilt 1946 · S/N 11AC-833N9199LO Neill Mark B · Pinckney, MIS/N 34-72N91FTLegassey Matthew G · Millinocket, MEBuilt 1966 · S/N 107N91PVMassimini Sebastian V · Arlington, VAS/N 1005-2006N91RARare Aircraft Ltd · Faribault, MNBuilt 2003 · S/N 472-2003N9201ERasmussen Raleigh C · Seattle, WABuilt 1946 · S/N 11AC-835N9202EJulian Stan Thomas · Holt, FLBuilt 1946 · S/N 11AC-836N9204EBlecha Donald H · Valley Center, KSBuilt 1946 · S/N 11AC-838N920CJJones Alva L · Craig, COBuilt 1960 · S/N 56N9210ET&B Aviation LLC · Waukesha, WIBuilt 1946 · S/N 11AC844N9211EVx Aircraft Services LLC · Batesville, ARBuilt 1946 · S/N 11AC-845N9214EGehle Roger D · South Lyon, MIS/N 11AC-848N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9224ETuskegee Airmen National Historical Museum · Detroit, MIBuilt 1946 · S/N 11AC-858N9229EWeaver Dana · Saint Joseph, MOBuilt 1946 · S/N 11AC-863N922DEMichigan Aviation LLC · Commerce Township, MIBuilt 2013 · S/N 1117-2013
Back to AD 2000-25-02 R1