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.

N90976Muinos Jose M · York, PABuilt 1973 · S/N 343-73N90979Keyes Roger S · Las Vegas, NVBuilt 1973 · S/N 70-73N9097BIrvine Paul E · Antioch, CABuilt 1958 · S/N 7FC-178N9097LHoover Mark B · Wasilla, AKBuilt 1970 · S/N 789-71N90984Holt Ken C · Tillar, ARS/N 438-73N90987Registration Pending · Turner, MTRegistration pendingBuilt 1973 · S/N 907-73N90989Carson Daniel Fred Trustee · Great Falls, MTBuilt 1973 · S/N 439-73N9098CPritchett Flying Service LLC · Rolla, MOS/N 7BCM-372N9098LDavenport Ross K · Raleigh, NCS/N 794-71N90991Roth Douglas D · Lincoln, NEBuilt 1973 · S/N 346-73N90992Fried Bernard S · Spring Branch, TXBuilt 1973 · S/N 908-73N90993Crosswell Joe · Springtown, TXBuilt 1973 · S/N 441-73N90996Destefano Patrick S · Bryan, TXBuilt 1973 · S/N 443-73N90997Pond Timothy A · Middletown, OHBuilt 1973 · S/N 909-73N90998Culvar Philip M · Granite City, ILBuilt 1973 · S/N 347-73N9099BLazzaro Michael · Santa Clarita, CABuilt 1958 · S/N 7EC-648N909MPSky Guy LLC · Frankenmuth, MIBuilt 1972 · S/N 291-72N90AVCag Aircraft Holdings LLC · Crystal River, FLBuilt 1974 · S/N 462-74N90CABlue Max Aviation LLC · El Cajon, CABuilt 1976 · S/N 93376N90GEWc Three LLC · Wilmington, DEBuilt 2018 · S/N 1174-2018N90GKPruitt Russell · Athens, GABuilt 2021 · S/N 1192-2021N90GTHawk Aviation LLC · Buffalo, NYBuilt 2017 · S/N 1172-2017N90LALakeside Aerodome Ltd · Clermont, FLBuilt 1995 · S/N 1207-95N91004Dill Terry L · Delphi, INS/N 7FC-182N9102LCook James C · Auburn, ALBuilt 1971 · S/N 259-71N9104LKalman Engineering Inc · Pekin, ILS/N 261-71N9106EGreiser James K · Wauseon, OHBuilt 1946 · S/N 11AC-739N9106LShipman Jesse L · Honey Grove, TXBuilt 1970 · S/N 795-71N9107LJ P Aero Holdings Inc · Carson City, NVS/N 796-71N9108ELerch Mark Robert · San Angelo, TXS/N 11AC-741N9109LYellowbird LLC · Lititz, PABuilt 1970 · S/N 299-71N910DKUpside Down Holdings LLC · Sherman Oaks, CABuilt 2005 · S/N 1007-2005N9112EMott William R · Beach Lake, PABuilt 1946 · S/N 11AC-745N9112LRockey Bruce G · Bitely, MIBuilt 1970 · S/N 263-71N9113LZimin Carl E · Naknek, AKBuilt 1970 · S/N 300-71N9114LKeller Crop Surveillance LLC · Jonesboro, ARBuilt 1970 · S/N 301-71N9115LSavonen Stephen D · Ukiah, CABuilt 1970 · S/N 797-71N9116LShowers Of Blessings LLC · Fredericktown, MOBuilt 1970 · S/N 302-71N9117LWillkris Aviation Services LLC · Smithfield, VAS/N 303-71N9118EBranch Timothy O · Russellville, ARBuilt 1946 · S/N 11AC-753N9118LDavis Brett M · Madison, MEBuilt 1970 · S/N 305-71N9119EHorstman Edward B · Bigfork, MTBuilt 1946 · S/N 11AC-751N9119LPiercy Ronald S · Moses Lake, WABuilt 1970 · S/N 304-71N9120LHarper Kevin J · Valley Center, KSBuilt 1970 · S/N 799-71N9121ECunningham Frank D · Okeechobee, FLBuilt 1946 · S/N 11AC-752N9123LAppold Dave J · Bay City, MIBuilt 1970 · S/N 804-71N9124EUnzicker Keith R · Benson, ILBuilt 1946 · S/N 11AC-758N9126EAlajoki Roger W · Menahga, MNBuilt 1946 · S/N 11AC-759N9126LHager David L · Barney, NDBuilt 1971 · S/N 308-71N9127RRegistered aircraftBuilt 1958 · S/N 7GC-14
Back to AD 2000-25-02 R1