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.

N3112QWelch Phillip A · Abilene, TXBuilt 1977 · S/N 28-7710023N3112WAbba Shield LLC · Kalispell, MTS/N 3255036N3114ATavallaee Mehran Monazam · Crossville, TNBuilt 2008 · S/N 3257490N3114XNorthgate Aviation Inc · Chico, CABuilt 2005 · S/N 3232052N3116CNorthfork Aviation LLC · Columbia, MOS/N 3246233N3117KDegatech Systems Inc · Van Nuys, CABuilt 2005 · S/N 3257398N3117QLynch Mark E · Granite Bay, CABuilt 2005 · S/N 3257403N311AWWidener Adam S · Sharpsburg, GABuilt 1974 · S/N 28-7525015N311GAtp Taa LLC · Wilmington, DES/N 2881422N311NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881904N311SEDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 2003 · S/N 3232011N3120ETandberg Kjell · Beverly Hills, FLBuilt 2005 · S/N 3257400N3120TMcbride Matthew T · Eagle River, WIBuilt 2006 · S/N 3257417N3121VCochise Community College · Douglas, AZBuilt 2006 · S/N 2843626N31222Dc Air LLC · Lebanon, MOBuilt 2004 · S/N 3257354N3122EKantec Inc · Cary, NCBuilt 1999 · S/N 2843250N31241Hotel Charlie Aero LLC · Marshville, NCBuilt 2006 · S/N 3246234N3126WHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2006 · S/N 2843621N3129BRaabe Craig A · West Hartford, CTBuilt 2006 · S/N 3257415N312ABSmith Kenneth R · Senoia, GAFirst renewal noticeBuilt 1978 · S/N 28R-7803120N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590N312CNN312cn LLC · Prescott, AZBuilt 1980 · S/N 28R-8031023N312ESGolden Age N312es LLC · Norwalk, IABuilt 2022 · S/N 2881587N312TMVan Hofwegen Douglas E · Spencer, IABuilt 1973 · S/N 28-7305382N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107N3132FN3132f LLC · Metairie, LABuilt 1973 · S/N 32-7440023N3133QLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1977 · S/N 28-7716138N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117N31377Piercy Brian A · Kalispell, MTBuilt 1978 · S/N 32-7840126N31380Aldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7840127N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554N31386S&L Aircraft LLC · Port Trevorton, PABuilt 1978 · S/N 28R-7837233N31388Sisk Farms LLC · Hopkinsville, KYBuilt 1978 · S/N 32-7840128N3138BBuck Enterprises LLC · Henderson, NVBuilt 2006 · S/N 3255044N31396Pucciarelli Albert J · Ridgewood, NJBuilt 1978 · S/N 32-7840129N31397Ial Corp · Lewes, DES/N 32R-7885093N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013N313AMRademacher John · Cottonwood, AZBuilt 1979 · S/N 28-8011015N313DCRegistered aircraftBuilt 1978 · S/N 28-7816591N313EMKjta LLC · Renfrew, PABuilt 1977 · S/N 28R-7703275N313LNBazal Jared W · Castle Rock, COS/N 28-2571N313PKCampbell James D · Palo Alto, CABuilt 1976 · S/N 32R-7780037N313PPMw Collins Inc · Cobbtown, GABuilt 2006 · S/N 3255051N313RBGlenn Simmons LLC · Point Lookout, NYBuilt 1978 · S/N 32R-7887157N313WMKafer Mark T · Colleyville, TXBuilt 1965 · S/N 28-2678N313ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881640N31400Druidia Group LLC · Downingtown, PABuilt 1978 · S/N 28-7816557N31401Fox Flying Club Inc · Wheaton, ILBuilt 1978 · S/N 28R-7837234
Back to AD 87-08-08 R3