OpenAirDocs.org
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.

N85454Rezich Nicholas R · Green Bay, WIBuilt 1946 · S/N 7AC-4194N85455Guidroz Brad F · Opelousas, LABuilt 1946 · S/N 7AC-4195N85459Owens Joseph E · Winnfield, LABuilt 1946 · S/N 7AC-4199N85463Maly Gerald J · Meadowlands, MNBuilt 1946 · S/N 7AC-4203N85464Spirit Of Superior LLC · Superior, WIBuilt 1946 · S/N 7AC-4204N8547Carlson Cory R · Trail, MNBuilt 1973 · S/N 914-73N85470Mcguire Michael D · Lake Stevens, WAS/N 7AC-4210N85479Appel David E · Redfield, SDBuilt 1946 · S/N 7AC-4219N8547ECarpenter Lionel Lee · South Fork, COBuilt 1959 · S/N 7GC-98N8548Collum Aviation LLC · Milton, FLBuilt 1973 · S/N 72-73N85480Carr Nathan A · Tecumseh, MIBuilt 1946 · S/N 7AC-4220N85486Wheaton Eric J · Gig Harbor, WABuilt 1946 · S/N 7AC-4226N8548EPingel Ralph C · Saint Peters, MOBuilt 1959 · S/N 7FC-348N8549Koenig Steven T · Ostrander, OHBuilt 1973 · S/N 351-73N85491Zingery Michael G · Shepherd, MIBuilt 1946 · S/N 7AC-4231N85499Mitchell Charles M · Ocala, FLBuilt 1946 · S/N 7AC-4239N8549EDrageset Denvero · Isabel, SDS/N 7GC-99N85502Stoltzfus Karl D · Homer, AKBuilt 1946 · S/N 7AC-4242N85505Schnatz Benjamin A · Valley, NEBuilt 1946 · S/N 7AC-4245N8550EHarloff David F · Lehigh Acres, FLBuilt 1959 · S/N 7FC-351N85510Irvine Hollis Eugene Jr · Greenwich, NJS/N 7AC-4250N8551VTall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N 793-75N8552Stogsdill Daniel D · Sahuarita, AZS/N 454-73N85522Barrett Joseph E · Lagrange, OHBuilt 1946 · S/N 7AC-4262N85523Lunde Ryan · Wausau, WIBuilt 1946 · S/N 7AC-4263N85528Bz Airworks · Eunice, LABuilt 1946 · S/N 7AC-4268N8552VBurkey Dale · Walnut, ILBuilt 1974 · S/N 493-75N85533Schutze Curt K · Knoxville, TNBuilt 1946 · S/N 7AC-4273N85534Rinker Kraig G · Winlock, WAS/N 7AC-4274N85537Agaliotis Paul E · San Martin, CABuilt 1946 · S/N 7AC-4277N85543Willson Henry M Jr · Pioneer, OHBuilt 1946 · S/N 7AC-4283N85544Miller James D · Wilmington, NCBuilt 1946 · S/N 7AC-4284N85547Roberts Jean A · Roberts, ILBuilt 1946 · S/N 7AC4287N85549Stock Gale C · Kirksville, MOBuilt 1946 · S/N 7AC-4289N8554VPaulson Marshall R · Kenai, AKBuilt 1974 · S/N 1070-75N85551Hanson Shirley M · Pentwater, MIBuilt 1946 · S/N 7AC-4291N85563Freeman Christopher D · Kingsbury, TXBuilt 1946 · S/N 7AC-4305N85564Jaquays Jeffrey C · Maryville, TNBuilt 1946 · S/N 7AC-4306N85568Fesmire Wilson M · Dyer, TNBuilt 1946 · S/N 7AC-4310N8556VParis Charles F · Pioneer, LABuilt 1974 · S/N 794-75N85571Cantley Richard W · Bluff City, TNBuilt 1946 · S/N 7AC-4313N85574Welch Ronald J · Viroqua, WIBuilt 1946 · S/N 7AC-4316N8557VBurton Michael B · Coweta, OKBuilt 1974 · S/N 496-75N85581Mcbride Mark · Sutton, MABuilt 1946 · S/N 7AC-4324N85582Hermann Vela M · Saint Louis, MOBuilt 1946 · S/N 7AC-4325N85585Brauer Eric M · Signal Mountain, TNS/N 7AC-4328N85587Broderson Dennis L · Port Townsend, WABuilt 1946 · S/N 7AC-4330N8558EZurinsky Richard · Port Orchard, WABuilt 1959 · S/N 7HC-7N85590Newton Dale H · Louisville, OHS/N 7AC-4333N85591Lucas Phillip J · West Sacramento, CABuilt 1946 · S/N 7AC-4334
Back to AD 2000-25-02 R1