OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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.

N4859LDavinci Ventures Inc · Bolingbrook, ILBuilt 1967 · S/N 28-4211N4859TRamirez-Pagan Abelardo · Copperas Cove, TXBuilt 1972 · S/N 28-7205210N485AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843749N485BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881785N485GAAlexander Glynn M · Miramar Beach, FLS/N 32-8006093N485PBlackstone Stephen E · Southampton, NJBuilt 1965 · S/N 28-21078N4860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842237N4861LPodolinski Frank · Greensburg, PABuilt 1967 · S/N 28-4213N4862LGunter Gordon D · Green River, WYBuilt 1968 · S/N 28-4216N4863LZimmerman Marlin · Muscoda, WIBuilt 1967 · S/N 28-4217N4863SHogs LLC · Georgetown, SCBuilt 1970 · S/N 32-1290N4864FFreely James John · Marshall, VAS/N 28-7790069N4864LRegistration Pending · Boone, NCRegistration pendingBuilt 1967 · S/N 28-4218N4865SBowman Steven R · Manteo, NCBuilt 1970 · S/N 32-1296N4867L23 Right LLC · Kalispell, MTBuilt 1967 · S/N 28-4221N4868LWinningham Matthew P · Prattville, ALBuilt 1968 · S/N 28-5123N4869BSchaffer Brandon T · Vlg Of Lakewd, ILBuilt 1984 · S/N 32-8424002N486BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881786N486DMMoes Sarah J · Rossford, OHS/N 32-286N486FLBaker Donnie · Christiana, TNBuilt 1971 · S/N 28-7125295N486MAOrange Wing Aviation Inc · Wilmington, DEBuilt 2006 · S/N 2843636N486PRichardson Joshua R · Mobile, ALBuilt 1965 · S/N 28-21079N486PARegistered aircraftBuilt 2023 · S/N 2881621N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225N4870TBailey Charles G · Phoenix, MDBuilt 1972 · S/N 32-7200026N4870UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842238N4871CFalvey Paul J · Edgartown, MABuilt 1984 · S/N 28-8490101N4871SLaingkids LLC · Lewes, DES/N 32-7100017N4872LMartin Marvin J · Conrath, WIBuilt 1968 · S/N 28-4227N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229N4874SShores Financial LLC · Thayer, ILBuilt 1971 · S/N 32-7100022N4874TSmith Richard R Sr · Wellington, NVS/N 28R-7235128N4875FVan Kirk Ronald · Wichita Falls, TXBuilt 1976 · S/N 28-7725033N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057N4877LTxp Designs LLC · Jasper, INS/N 28-4243N4877SRegistered aircraftBuilt 1970 · S/N 32-7100001N4878LPeg Aviation LLC · Cedar Hill, TNBuilt 1967 · S/N 28-4244N4878SGarmin International Inc · Salem, ORBuilt 1971 · S/N 32-7100002N4878TLorbiecki John E · Hubertus, WIS/N 28-7205214N4879SWilliams Michael J · Mount Laurel, NJBuilt 1970 · S/N 32-7100003N4879TCombs Kenneth E · Canyon, TXBuilt 1972 · S/N 28-7225228N487AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843750N487BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881787N487FLCarr Richard L · Cameron, WIBuilt 1971 · S/N 28-7125297N487PLoehrer Michael A · Saint Cloud, MNBuilt 1965 · S/N 28-21080N4880LHigginbotham Rome A · Zanesville, OHBuilt 1967 · S/N 28-4246N4880TItechtives Company LLC · Purcellville, VABuilt 1972 · S/N 28-7225229N4881LHoneycutt Stephen D · Ukiah, CABuilt 1967 · S/N 28-4247
Back to AD 87-08-08 R3