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.

N495DSDelaware State University · Dover, DEBuilt 1997 · S/N 2844012N495FLUrban Thomas L · Glencoe, MNBuilt 1971 · S/N 28-7125310N495LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020023N495WFWalters Steven M · Marathon, FLBuilt 1995 · S/N 3213097N4960FLc Aviation LLC · Fort Meade, FLS/N 32-7640123N4960LWynn Wora A · Scottsdale, AZBuilt 1967 · S/N 28-4331N4961JJones Charles W · La Follette, TNBuilt 1968 · S/N 28R-30710N4961LKral Aircraft LLC · Ocala, FLBuilt 1967 · S/N 28-4332N4961THatami-Nezhad Jamshid · Encino, CABuilt 1972 · S/N 28-7225289N4962JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30711N4963LBakk Dale A · Nikiski, AKBuilt 1967 · S/N 28-4334N4964JShteyn Vladlmir · Huntingdon Valley, PABuilt 1968 · S/N 28R-30714N4964LMcallister Robert G · Santee, CABuilt 1967 · S/N 28-4335N4965LCurrent Jim · Hannibal, MOS/N 28-4336N4966FDj&A Enterprises LLC · Sevierville, TNBuilt 1976 · S/N 32R-7680494N4966LNelson Osea C · Sheridan, WYBuilt 1967 · S/N 28-4337N4967JB F D Inc · Newington, CTBuilt 1968 · S/N 28R-30718N4967SLambert Enterprises Inc · Minneapolis, MNS/N 28R-35687N4967TN4967t LLC · Evansville, INBuilt 1972 · S/N 28R-7235164N4968JOperation Stinky Weasel LLC · South Lyon, MIBuilt 1968 · S/N 28R-30719N4968LSchoolcraft William F · Middletown, OHBuilt 1967 · S/N 28-4339N4969LLubnau Berdy G · New Braunfels, TXBuilt 1967 · S/N 28-4341N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074N4970LAzflyers LLC · Gilbert, AZBuilt 1967 · S/N 28-4344N4970SMapoles Aviation · Pace, FLS/N 28R-35690N4971JCreasy Frank Edward III · Suffolk, VABuilt 1968 · S/N 28R-30722N4971LNathanson David · Los Angeles, CAS/N 28-4345N4971TRegistered aircraftBuilt 1972 · S/N 28-7225295N4972LRush City Flyers · North Branch, MNBuilt 1967 · S/N 28-4346N4973JTroftgruben Gregory G · Buxton, NDS/N 28R-30724N4973LRahjes Luke D · Kensington, KSBuilt 1967 · S/N 28-4347N4974LPotratz Douglas R · Oshkosh, WIBuilt 1967 · S/N 28-4348N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727N4975LMcnabb Brandy T · Milton, FLS/N 28-4349N4976LLawrence Kenneth White · Chuckey, TNBuilt 1967 · S/N 28-4350N4976SLogsdon David · Carmel, INBuilt 1970 · S/N 28R-35692N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730N4977LApple Tree Aviation LLC · Gibsonia, PABuilt 1967 · S/N 28-4352N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696N4979FEdward Jones Risk Placement Corp · Voorhees, NJS/N 28-7790081N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567N497FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125314N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229N4981LBasinger Robert C · Freedom, PABuilt 1967 · S/N 28-4356N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701N4983LDecoster Vaughn A · Greenwood, ARBuilt 1967 · S/N 28-4358
Back to AD 87-08-08 R3