OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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.

N95192Kilo Fox Aviation LLC · Saint Joseph, MIBuilt 1969 · S/N 28-25837N95198Hippen Justin L · Virginia, NEBuilt 1969 · S/N 28-25839N9519JBarlia David L · Anaheim, CABuilt 1966 · S/N 28-3643N951GTK And M Aviation LLC · Palm Harbor, FLBuilt 1979 · S/N 32-7940036N951NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881925N951TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881951N95203Neptune Aviation Services Inc DBA · Missoula, MTBuilt 1969 · S/N 28-25840N9520JStaples Laurence C · Makanda, ILBuilt 1966 · S/N 28-3645N95211Massey Aviation LLC · Ashburn, GABuilt 1969 · S/N 28-25843N95217Laight Kevin · Greeneville, TNS/N 28-25844N9521JGeesaman Brian K · Mount Pleasant, PABuilt 1966 · S/N 28-3739N9521WFlap Happy LLC · Sheridan, WYBuilt 1967 · S/N 28-22948N95225Cherokee 95225 LLC · Provo, UTS/N 28-25851N9522WPrio Frank A · Milwaukee, WIBuilt 1967 · S/N 28-22949N95231Duncan Paul D · Norfolk, NEBuilt 1969 · S/N 28-25856N95236Plane Crazy LLC · Bennington, NEBuilt 1969 · S/N 28-25857N95237Klassen Glenn Kurt · Chandler, AZBuilt 1969 · S/N 28-25858N95238Date Greg · Spokane Valley, WABuilt 1969 · S/N 28-25859N9523JMichalka James R · Portage, MIBuilt 1966 · S/N 28-3648N9523WOberg Harry W C III · Evanston, WYBuilt 1967 · S/N 28-22950N95244Banas Darryl P · Waco, TXBuilt 1969 · S/N 28-25861N9524JZanella Paul J · Ballston Spa, NYBuilt 1966 · S/N 28-3649N95253Mmou LLC · Fort Worth, TXBuilt 1969 · S/N 28-25862N95255Herren Robert H · Lexington, KYBuilt 1969 · S/N 28-25863N95259Erickson Landon S · Fairbanks, AKBuilt 1969 · S/N 28-25866N9525JSandpiper Nag LLC · Louisville, KYBuilt 1966 · S/N 28-3650N95264Jorquez Andrew D · Santa Paula, CABuilt 1969 · S/N 28-25867N95265Red River Aviation Services LLC · Altus, OKS/N 28-25868N95266Walton Robert · Franklin Lakes, NJS/N 28-25869N9526JWorthington Brian · Las Vegas, NVBuilt 1966 · S/N 28-3652N9526KReyn/Craft Wildside Aviation LLC · Athens, ILS/N 28-7690257N9526WMarch Theodore M · Fernley, NVBuilt 1967 · S/N 28-22954N95270Get Away 1 LLC · St George, UTBuilt 1969 · S/N 28-25870N95271Ederer Martin J · Baraboo, WIBuilt 1969 · S/N 28-25871N9527JOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 28-3653N9527WDieck Michael J · Fayetteville, NCFirst renewal noticeS/N 28-22955N95285Bangerter James Alan · Indn Hbr Bch, FLBuilt 1969 · S/N 28-25875N9528JGiles Dennis E II · Pearson, WIBuilt 1966 · S/N 28-3654N952AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843804N952DAEppes Michael Scott · Austin, TXBuilt 1995 · S/N 3213103N952NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881370N952TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881952N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878N95303Morrison Robert F II · Denton, TXS/N 28-25879N95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeBuilt 1969 · S/N 28-25880N9530JNations Jeffrey L · Kingshill, VIS/N 28-3657N9530WGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28-22958N95315Valencic Adam · Apopka, FLBuilt 1969 · S/N 28-25885N9531JGrayhawk Flight Training LLC · Lucas, TXBuilt 1966 · S/N 28-3658N9531KCline Timothy E · Rome, GABuilt 1976 · S/N 28-7610104
Back to AD 87-08-08 R3