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.

N86607Yellow Decathlon LLC · Algonquin, ILBuilt 1973 · S/N 138-74N8660VStaton Brian L · Lonoke, ARBuilt 1975 · S/N 314-75N86612Sale Reported · Wilmington, DESale reportedBuilt 1973 · S/N 1008-74N86617Teeters Esme · Duncansville, PABuilt 1974 · S/N 676-74N8662Corthell Andrew W · Andover, MNBuilt 1973 · S/N 920-73N86621Colson Carl · Blunt, SDBuilt 1973 · S/N 645-74N86625Ready Aim Flyer LLC · New Castle, DEBuilt 1973 · S/N 646-74N8662VMaxon Raymond D · Santa Paula, CAS/N 1091-75N8663Ireland Kel · Fredericksburg, TXBuilt 1973 · S/N 76-73N86630Pressley Aviation LLC · New London, NCBuilt 1974 · S/N 140-74N86633Gregor John E · Fairbanks, AKS/N 682-74N86634Shipp Donald E · Wyoming, MNBuilt 1973 · S/N 1012-74N86636Olson Kenneth L · Raymond, WABuilt 1973 · S/N 648-74N86637Stohr Beuford G · Woden, IABuilt 1974 · S/N 141-74N8664Page Jason · Medina, TNBuilt 1973 · S/N 463-73N86641Aa Stearman LLC · Lewisville, TXBuilt 1974 · S/N 427-74N86642Tedstrom Robert E · Bartlesville, OKBuilt 1974 · S/N 1025-74N86647Reuhl Kenneth R · Piscataway, NJS/N 295-74N8664VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 169-75N86651Wilbur Andrew E · Boyd, WIS/N 439-74N86654Dillard Ronald G · Lebanon, TNBuilt 1974 · S/N 1014-74N8665VMaisel Chad L · Plano, TXBuilt 1975 · S/N 193-75N8667VBloomquist Ronald D · Mooresburg, TNBuilt 1975 · S/N 17075N8668Freppon Farm Equipment LLC · Wilmington, DEBuilt 1973 · S/N 921-73N86682Twardokens Eva M · Aptos, CABuilt 1974 · S/N 143-74N86711Crane David D · Cadott, WIBuilt 1974 · S/N 654-74N86713Tuckerman Flying Service Inc · Tuckerman, ARBuilt 1974 · S/N 681-74N86714Odonnell Daniel V · Dover, DEBuilt 1974 · S/N 10-74N86715Yellerhammer LLC · Warner Robins, GABuilt 1974 · S/N 1017-74N86727Murray Eric J · Kamas, UTBuilt 1974 · S/N 656-74N8672VHarris Kenneth L · Greeley, COBuilt 1975 · S/N 174-75N86738Myran Kenneth · Taylor, NDBuilt 1974 · S/N 657-74N86742Parker James T · Palmer, AKBuilt 1974 · S/N 431-74N8674VIberlin Ranch · Gillette, WYBuilt 1975 · S/N 826-75N86752J&M Aviation Supply Inc · Shreveport, LABuilt 1974 · S/N 292-74N8677VAlbij3 LLC · Milton, FLBuilt 1975 · S/N 315-75N86796Perkins Brad · Thomas, OKBuilt 1974 · S/N 659-74N867SRHangar R LLC · Irvington, ALS/N 7AC-6318N86807Wells Jeffrey V · Mackay, IDS/N 22-74N86813Holton Allen M Jr · Torrance, CABuilt 1974 · S/N 1016-74N86820Piercy Ron · Moses Lake, WABuilt 1974 · S/N 433-74N86822Hofer Gary D · Huron, SDBuilt 1974 · S/N 672-74N86828Robinson William D · Greer, SCBuilt 1974 · S/N 1019-74N86834Cardinal Aviation Inc · Murray, KYBuilt 1974 · S/N 435-74N86838White Sean Patrick · Fairbanks, AKS/N 688-74N8683VDaniel Shannon B · El Dorado Springs, MOBuilt 1975 · S/N 1098-75N86846Woolard Farms Leasing Inc · Corning, ARBuilt 1974 · S/N 669-74N86847Kilbourn James A · Happy Valley, ORS/N 432-74N86849Sweet Ranch Inc · Hyannis, NEBuilt 1974 · S/N 63-74N86854Moore Planting Co Inc · Cary, MSBuilt 1974 · S/N 6-74
Back to AD 2000-25-02 R1