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.

N7479WTcheutchua Romeo J · Portales, NMBuilt 1963 · S/N 28-1389N747BZHilton Head Flyers LLC · Liberty, SCBuilt 1974 · S/N 28-7515019N747CVGeorge Walker Field Inc · Bedminster, NJBuilt 1999 · S/N 2843245N747GVPlane Sol LLC · Laredo, TXBuilt 2022 · S/N 2881586N747JSAlameda Aero Club · Alameda, CABuilt 1967 · S/N 28R-30365N747MWWhite Michael Jay · Oakland Park, FLS/N 28-4657N747VTThomson Victor J · Denton, MTBuilt 1968 · S/N 28-11195N7480WYessmann Dan Seiji · Gardena, CABuilt 1963 · S/N 28-1390N7481JShaffer John W · Titusville, PABuilt 1968 · S/N 28R-30839N7481WFlying Nova LLC · Tacoma, WABuilt 1963 · S/N 28-1391N7483RCarpenter Bruce E · Monroe, NYBuilt 1966 · S/N 28-22035N7483WPack Jon C · Blue Ridge, GABuilt 1963 · S/N 28-1393N7484WSotvik Tanner · Devils Lake, NDBuilt 1963 · S/N 28-1394N7485WBond Jesse · Pulaski, TNS/N 28-1395N7486WBaney David · Summitville, INBuilt 1963 · S/N 28-1396N7487RDeschamp Patrick B · Bottineau, NDS/N 28-22040N74889Unlimited Aviation LLC · Webster, NYBuilt 1967 · S/N 28-4519N7488RSimpson Kevin B · Newberg, ORBuilt 1966 · S/N 28-22042N7488WAnuradha Jairam · Camas, WABuilt 1963 · S/N 28-1399N7489JMayer Thomas D · Medford, ORBuilt 1968 · S/N 28R-30849N7489WHostetler Kevin · Green Forest, ARBuilt 1963 · S/N 28-1400N748PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881190N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035N748RSGrady Michael J · Farmington, NMBuilt 1968 · S/N 28-5230N7490WCome Fly With Me LLC · Columbiana, ALBuilt 1963 · S/N 28-1401N7491WWillard Michael W · Boonville, NCS/N 28-1402N7492JClassic Air Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30852N7492WN7492w LLC · Spicewood, TXBuilt 1963 · S/N 28-1405N7493JRegistered aircraftBuilt 1968 · S/N 28R-30854N7493RWalcher James W · Wilmington, ILBuilt 1966 · S/N 28-22047N7493WNonn Lidia G · Appleton, WIBuilt 1965 · S/N 28-2900N7494WLandreth Homer W · Peoria, AZBuilt 1963 · S/N 28-1407N7495JDreamair LLC · Fargo, NDBuilt 1968 · S/N 28R-30856N7498JSawyer Steven A Md · Hampton, GABuilt 1968 · S/N 28R-30860N7499RCart Caleb L · Eunice, LAS/N 28-22054N7499WWoodward Adam B · Fort Collins, COBuilt 1963 · S/N 28-1412N749CSBower John M · Santa Cruz, CABuilt 1976 · S/N 28R-7635222N749PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881244N74LPMendota Flyers LLC · Middleton, WIBuilt 1968 · S/N 28-25196N74MHRichmond Wheeler LLC · Marshfield, WIBuilt 1974 · S/N 28-7415465N74PAApplegate David L · Oakland, IAS/N 287515055N74THDe Gracia Jack P · Orlando, FLBuilt 1966 · S/N 28-22308N74WRPrecision Millwright & Machine Inc · Villa Park, ILBuilt 1974 · S/N 28-7415458N74WWWhitewind Co · Windsor Locks, CTBuilt 1999 · S/N 3246144N75005Spiesman William J · Austin, TXBuilt 1976 · S/N 28-7690279N75008Rector Allen · Marshall, VAS/N 28-7610107N7500JNour George E · Eatonton, GAS/N 28R-30863N7500RSzymanski Tadeusz C · Fort Myers, FLBuilt 1966 · S/N 28-22055N7500WGajewski Richard G · Naples, FLBuilt 1963 · S/N 28-1413N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246
Back to AD 87-08-08 R3