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.

N7056WEustace Daryl R · Scottsboro, ALBuilt 1962 · S/N 28-824N7057RContreras Robert G · Norman, OKBuilt 1966 · S/N 28-21756N7057WWatkins Travis · Haughton, LABuilt 1962 · S/N 28-829N7058RMoss Harold E II · Overland, MOBuilt 1966 · S/N 28-21757N7058WRoman Donald M Jr · New Middletown, OHBuilt 1962 · S/N 28-810N7059WMartin Gerard A · Boston, KYBuilt 1962 · S/N 28-811N705CFStanbridge Dale · Phoenix, AZBuilt 1979 · S/N 28-7916339N705FLSue Christina Alicia · San Antonio, TXBuilt 1972 · S/N 28-7225290N705MMLeon Marco M · Broadlands, VABuilt 1978 · S/N 28-7816648N705NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881022N705WHSky Craft LLC · Powell, OHBuilt 1978 · S/N 28R-7918019N7060WHorst Gregory J · Glen Burnie, MDS/N 28-819N7063RWirt Wayne A · Llano, CABuilt 1966 · S/N 28-21763N7064RNagel Aaron J · Alliance, OHBuilt 1966 · S/N 28-21764N7064WDalotto Gianpaul · Deridder, LABuilt 1962 · S/N 28-838N7065WShirley Janice · Warsaw, NYBuilt 1962 · S/N 28-839N7066CFrampton Charles R · Moore, OKBuilt 1975 · S/N 28-7615041N7066RBarreto Colon Wilfredo · Lake Dallas, TXBuilt 1966 · S/N 28-21767N7069RMccoy Evan Tyler · Tullahoma, TNBuilt 1966 · S/N 28-21770N7069WBirmingham Michael F · Goldsboro, NCBuilt 1962 · S/N 28-818N706FLTime Flys Idaho LLC · Clarkston, WAS/N 28-7225300N706NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881023N706RAChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843899N7070RRegistration Pending · Seward, NERegistration pendingBuilt 1966 · S/N 28-21771N7070WFullerton Brice · Oroville, WAS/N 28-849N7071RKarabulut Semih · North Little Rock, ARS/N 28-21772N7071WTeigen Travis S · Glenwood City, WIBuilt 1962 · S/N 28-851N7072RMckinley Matthew R · Sault Sainte Marie, MIS/N 28-21773N7072WNelson David L · Laporte, INBuilt 1962 · S/N 28-852N7073RMorris Gregory A · Arlington, TXBuilt 1966 · S/N 28-21774N7073WTjc Aviation Group LLC · Rolling Meadows, ILBuilt 1962 · S/N 28-853N7074RCl Finney Aviation LLC · Benton, KSBuilt 1966 · S/N 28-21775N7075RYoungs William R · Grand Blanc, MIBuilt 1966 · S/N 28-21776N7077WMcclure Jared B · Claremore, OKBuilt 1962 · S/N 28-859N7078RSeidel Electrical Services Inc · Salinas, CAS/N 28-21779N7079RKoerner Aviation Inc · Kankakee, ILBuilt 1966 · S/N 28-21781N707JWIsland Aviation LLC · Fleming Island, FLBuilt 1978 · S/N 32R-7885168N707KBNorcal Home Loans Inc · Placerville, CABuilt 1980 · S/N 32-8006099N7081HSale Reported · Lewes, DESale reportedBuilt 1971 · S/N 32-7100028N7081RStearns Edwin B Jr · Eloy, AZS/N 28-21783N7083RJohnson David G · Starkville, MSBuilt 1966 · S/N 28-21785N7083WBell O Z · Victorville, CABuilt 1962 · S/N 28-869N7084WGrahn James A · Las Vegas, NVBuilt 1962 · S/N 28-870N7085RDubois Aviation Inc · Chino, CABuilt 1966 · S/N 28-21788N7085WBinder Jeffrey K · Brazil, INBuilt 1962 · S/N 28-871N7087ACmcq Flight LLC · Park River, NDBuilt 1970 · S/N 28-26518N7087RSensabaugh Randall W · Stanton, TNBuilt 1966 · S/N 28-21790N7087WHill Corey · Douglas, ALBuilt 1962 · S/N 28-873N7088WMarshall Xavier T · Carson, CABuilt 1962 · S/N 28-875N7089RFlying Tigers Aviation LLC · Mars, PABuilt 1966 · S/N 28-21792
Back to AD 87-08-08 R3