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.

N2927MCooney Francis M · Sunriver, ORBuilt 1977 · S/N 28R-7837106N2927QWifa (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 28R-7737043N29282Avance Aviation LLC · Burlington, MABuilt 1979 · S/N 28-7990444N29285Zrelak Patrick DBA · Apple Valley, CABuilt 1979 · S/N 28-7990446N2928AVista Aircraft Lc · Papillion, NES/N 32-7940212N2928XBurger Andrew J · Cincinnati, OHBuilt 1979 · S/N 32-7940216N29296Crosby Gck LLC · Fort Worth, TXBuilt 1979 · S/N 28-7990447N292AWPalmetto Air LLC · Spartanburg, SCS/N 32-7840061N292EHGlorybe2 LLC · Saluda, SCBuilt 1965 · S/N 28-20943N292HCarlisle Services LLC · Pine Mountain, GABuilt 1999 · S/N 3257094N292HPMissimer N292hp LLC · Petaluma, CABuilt 2004 · S/N 2843587N292JEEquinoxx Flight Systems LLC · Duluth, GABuilt 2022 · S/N 2881547N292LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020014N292LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881182N292MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843776N292RMJunk Troy A · Wshngtn Ct Hs, OHBuilt 1968 · S/N 28R-30955N292WRabbitt Timothy N · Austin, TXBuilt 2026 · S/N 28010001N292WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020053N29305Mbs Aircraft Inc · Saginaw, MIBuilt 1979 · S/N 28R-7918134N2930QL A B Flying Service Inc · Renton, WAS/N 32R-7780269N2930RSouthern Warriors International Inc · Port Saint Lucie, FLBuilt 1969 · S/N 28R-35332N29310Talbert James D · Alamogordo, NMBuilt 1979 · S/N 28R-7918139N2931MNsain Flight Ops LLC · Fort Worth, TXBuilt 1977 · S/N 28R-7803154N2931QSky Dasher Inc · Wilmington, DES/N 32R-7780270N2932FIceman Holdings LLC · Greer, SCBuilt 1979 · S/N 32-7940218N2932QK & W Aviation LLC · Jackson, TNBuilt 1977 · S/N 32-7740055N2933AFlying Particles Inc · Livermore, CABuilt 1979 · S/N 28-7916549N2933VJones David T · Las Vegas, NVBuilt 1979 · S/N 28-7916551N2934CPolte Steven J · Knoxville, TNBuilt 1979 · S/N 28-7916554N2935GWilliams Herbert B Jr · Pensacola, FLBuilt 1979 · S/N 28-7990560N2935NMartineau Robert Tyler · Crested Butte, COBuilt 1979 · S/N 28-7990562N2935SJacksonville Airport Authority · Jacksonville, ILBuilt 1979 · S/N 28-7990563N2935UBraner Richard C · Oakdale, CABuilt 1979 · S/N 28-7990565N2935VHungerford Mark T · Swanton, VTBuilt 1979 · S/N 28-7990566N29361Blomgren Roy E · Woodstock, ILS/N 28-7911176N2936NTailwinds Aviation LLC · Crystal Lake, ILBuilt 1979 · S/N 28R-7918229N2936QA&J Aircraft Leasing Inc · Burlington, COS/N 28-7716126N29374Heartland Aviation Inc · Alliance, NEBuilt 1979 · S/N 28-7911178N29376Registered aircraftBuilt 1979 · S/N 28-7911179N2937BHaas Terry D · New Tripoli, PABuilt 1979 · S/N 28R-7931261N2937NDelaware State University Aviation Program · Dover, DEBuilt 1979 · S/N 28-7916559N2937QCharles Sargent Irrigation Inc · Broken Bow, NES/N 28-7716127N2937RCross Winds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-7916560N2937XOrtega Tobin W · Juneau, AKBuilt 1979 · S/N 28-7990567N2938FFly Gateway Aviation Institute · New Castle, DES/N 28-7990573N2938UArcher Two Aviation LLC · Walnut Creek, CABuilt 1979 · S/N 28-7990574N29394Davis Kenneth Howard · Waxahachie, TXBuilt 1979 · S/N 28-7921033N2939JCaballeros Aircraft LLC · Snohomish, WABuilt 1979 · S/N 28-7990576N2939NPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 28R-7931263N2939Q7777 Aviation LLC · Bartow, FLS/N 28-7790425
Back to AD 87-08-08 R3