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.

N86863Pruitt Leland L · Jones, LABuilt 1974 · S/N 36-74N86872Chupito Sabrocito LLC · Paso Robles, CABuilt 1974 · S/N 1028-74N86879Knik Flying Club LLC · Anchorage, AKBuilt 1975 · S/N 856-75N8687VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 184-75N86883High Exposure Inc · Wilmington, DEBuilt 1974 · S/N 680-74N86885Mason Peter Trustee · Santa Paula, CABuilt 1974 · S/N 37-74N8688VHawkeye Aviation LLC · Newport, ARBuilt 1975 · S/N 1096-75N86890E-Commerce Education Foundation · Tulsa, OKBuilt 1974 · S/N 443-74N86892Goodman Jack · Memphis, TNBuilt 1974 · S/N 296-74N8689VZacheis Henry M · Fairbanks, AKBuilt 1975 · S/N 841-75N868DGGualandri Daniel J · North Port, FLBuilt 1946 · S/N 7AC-6207N86901Rudderow Preston Trustee · Anchorage, AKBuilt 1974 · S/N 23-74N86911Schneberger Bart A · Nome, AKBuilt 1974 · S/N 25-74N8691VAviation Specialists LLC · Wilmington, DES/N 1097-75N86928Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 32-74N8692VLohr Martin J · Petersburg, AKBuilt 1975 · S/N 831-75N86936Lewis Aviation Inc · Wilmington, DEBuilt 1974 · S/N 444-74N8693VMichael A Levenhagen · North Fort Myers, FLBuilt 1975 · S/N 185-75N86948Guglietta Jon R · Harwinton, CTBuilt 1974 · S/N 147-74N86950Dale Jane L · Willow, AKS/N 39-74N86953Madden Russell · Graford, TXBuilt 1974 · S/N 152-74N86954Breaking Wind LLC · Alabaster, ALBuilt 1974 · S/N 148-74N86957Swan Creek Flying Club · Ayr, NDBuilt 1974 · S/N 692-74N86959Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 1029-74N86968Crafted Enterprises LLC · Montrose, COS/N 40-74N86969Sperry Sails Inc · Marion, MABuilt 1974 · S/N 695-74N8696VMoynahan Thomas F · Newnan, GABuilt 1975 · S/N 515-75N86974Qualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 145-74N86977Ajs Aviation Inc · Spring Hill, FLBuilt 1974 · S/N 458-74N8697VFisher Kurt Adrian Trustee · San Luis Obispo, CABuilt 1975 · S/N 833-75N86983Hanson Curtis J · Peyton, COBuilt 1974 · S/N 1031-74N86985Thomas Lucas G · Beebe, ARBuilt 1974 · S/N 44-74N86986Nelson Michael R · Philip, SDBuilt 1974 · S/N 45-74N86989Webb Terry M · Montreal, MOBuilt 1974 · S/N 46-74N8698VNine 8 Victor Tailshare LLC · Kalispell, MTS/N 179-75N8699Blake Rodney · Trophy Club, TXBuilt 1973 · S/N 358-73N86992Shorey Ruby M · North Pole, AKBuilt 1974 · S/N 47-74N86993Jhs Inc · Helena, MTBuilt 1974 · S/N 55-74N869TTDimond Joan M · Birch Run, MIBuilt 1969 · S/N 157N86CYDawson J Stewart · Celina, TXBuilt 2008 · S/N 1073-2008N86RAAcrodocs LLC · Tallahassee, FLBuilt 2003 · S/N 925-2003N86RTInverted Aviation Inc · Walnut Cove, NCBuilt 1992 · S/N 682-92N86WJWalbridge James S · Mill Hall, PAS/N 38-72N87006Dow Terry D · Okarche, OKBuilt 1974 · S/N 50-74N87008Garrity Frank B · Durham, CABuilt 1974 · S/N 51-74N87009Wrench Heath · Lafayette, COBuilt 1974 · S/N 449-74N87015Legacy Lsa LLC · Lubbock, TXBuilt 1974 · S/N 702-74N87019Bates Paul L · Livermore Falls, MES/N 1032-74N87021Haugen Delos L · Burlington, NDBuilt 1974 · S/N 1033-74N87025Lundin Steven J · Carson City, NVBuilt 1974 · S/N 450-74
Back to AD 2000-25-02 R1