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.

N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N559JPNelson Scott E · Whispering Pines, NCBuilt 1978 · S/N 32R-7885276N559MANorwood Kenneth Trustee · Rogers, ARBuilt 2000 · S/N 3246159N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096N55AFRegistration Pending · Terre Haute, INRegistration pendingS/N 32-864N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55JDAviation Capital Management LLC · San Jose, CAS/N 28-7790579N55LDDouble R Airways LLC · Largo, FLBuilt 1998 · S/N 3246101N55LMQuinn Sean · Edmonds, WABuilt 1977 · S/N 28R-7703258N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55MJBarodge Equipment Leasing Inc · Fairmount, INBuilt 1980 · S/N 32R-8013068N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634N55XFCeb Enterprises LLC · Petal, MSBuilt 1972 · S/N 28-7325132N56007N56007 LLC · Burke, VABuilt 1973 · S/N 28-7325553N56008F R G III Inc DBA · Lincoln Park, NJBuilt 1973 · S/N 28-7305517N5600UCorey Marlin F · Choctaw, OKBuilt 1966 · S/N 28-22203N5600WFitzgerald Anthony M · Crete, NEBuilt 1962 · S/N 28-737N56015Ac Sales & Investments LLC · Hickory, NCBuilt 1973 · S/N 28-7305518N5601WTaylor Larry J · San Manuel, AZBuilt 1962 · S/N 28-738N56023Bennett Paul · Phoenix, AZBuilt 1973 · S/N 28R-7335336N5602VBam Aviation LLC · Celina, TXS/N 32R-7780345N5602WSaunders Nathaniel E · Muskegon, MIBuilt 1962 · S/N 28-739N56031Musser John R · Freeport, ILBuilt 1973 · S/N 28R-7335338N56032Umo Flight School LLC · Mount Olive, NCBuilt 1973 · S/N 28R-7335339N56033Larson Douglas R · Goodyear, AZBuilt 1973 · S/N 287310168N5603WElliot Harold F II · Pomeroy, OHBuilt 1962 · S/N 28-740N56041Haddad Joe · Charlotte, NCBuilt 1973 · S/N 28-7325562N5604UShumaker Grant H · Dakota Dunes, SDBuilt 1969 · S/N 28-26532N5604WHustedde Trucking LLC · Fayette, MOBuilt 1962 · S/N 28-741N56050Seidel Seth · Ellington, CTBuilt 1973 · S/N 28R-7335340N56055Murray Patrick Calvin Jr · Port Orchard, WABuilt 1973 · S/N 28-7325563N5605UN5605u LLC · Nottingham, NHBuilt 1969 · S/N 28-26534N5605WHammack Tyler S · Brush Prairie, WAS/N 28742N56063Powell James M III · Columbia, SCBuilt 1973 · S/N 28R-7335344N56066Trojan Aviation LLC · Kailua Kona, HIBuilt 1973 · S/N 28R-7335346N5607UWilliams Richard Dale · Tucson, AZBuilt 1969 · S/N 28-26535N5607WFrost Jack D II · Goodrich, MIS/N 28-745N56083Rock Solid Aviation LLC · Lake Charles, LABuilt 1973 · S/N 28-7325565N56085Donohue John T · Big Bear Lake, CABuilt 1973 · S/N 28R-7335348N56086Cacolici Dominic · Saint Petersburg, FLBuilt 1973 · S/N 28R-7335349N56088Wild River Flying Club Inc · Saint Croix Falls, WIBuilt 1973 · S/N 32-7340154N5608USchoenberger Amber J · Niceville, FLS/N 28-26537N56090Wood William J · Jackson, GABuilt 1973 · S/N 28-7325570N56095Jk Aviation LLC · Manteca, CABuilt 1973 · S/N 32-7340157N56098Wong Yi C · Aurora, COBuilt 1973 · S/N 28-7325571N5609USteves Landavator Service LLC · Oley, PAS/N 28-26539N560APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843763
Back to AD 87-08-08 R3