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.

N4640RSchotter Robin J · Seattle, WABuilt 1966 · S/N 28-21393N4641FCrosswinds Flying Club Inc · Bloomington, ILBuilt 1976 · S/N 28R-7635431N4641JN4641j LLC · Mulberry, FLBuilt 1968 · S/N 28R-30531N4641RWebb Patrick S · Chuckey, TNBuilt 1966 · S/N 28-21394N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400N4648JTutt Bryan · Louisville, KYS/N 28R-30542N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404N464CAAirfrank Inc · Hackensack, NJBuilt 1998 · S/N 3257054N464FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020064N464NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010018N464SPMeshik Ground Service LLC · Port Heiden, AKBuilt 1974 · S/N 32-7440159N4650JCrabtree Sandis · Jackson, OHBuilt 1968 · S/N 28R-30544N4651JReznik Real Estate LLC · Belton, SCBuilt 1968 · S/N 28R-30545N4652RSpringfield Flying Club Inc · Ludlow, VTS/N 28-21407N4653JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30547N4653RElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 28-21408N4654RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-21409N4655JCody Martell Racing Inc · Fort Myers, FLS/N 28R-30549N4655RFroeschl Christopher J · Roanoke, VABuilt 1966 · S/N 28-21410N4656JPeters David E · Sylvania, OHBuilt 1968 · S/N 28R-30550N4656RSheremeta David T · Beverly Hills, FLBuilt 1968 · S/N 28-24834N4657JHummel Aileen J · Fort Worth, TXBuilt 1968 · S/N 28R-30551N4658RRegistration Pending · Sand Springs, OKRegistration pendingBuilt 1966 · S/N 28-21413N4659RSchmitt Michael T · Danville, ILBuilt 1966 · S/N 28-21414N465CJAllegro Christopher J · Simi Valley, CABuilt 1967 · S/N 28-4465N465FARondeau Inc · East Norriton, PABuilt 2022 · S/N 28020065N4660ROgren William E · Red Wing, MNBuilt 1966 · S/N 28-21415N4661RSternberg Alexander J · Key Largo, FLBuilt 1966 · S/N 28-21416N4662JBigby Calvin J · Savannah, GAS/N 28R-30558N4663JMetro Flying Club · Gilbert, SCBuilt 1968 · S/N 28R-30559N4663RLockwood Michael C · Edmond, OKBuilt 1966 · S/N 28-21418N4664JDezelan Daniel · Fishers, INBuilt 1968 · S/N 28R-30562N4664RRd Aire LLC · Opelika, ALBuilt 1966 · S/N 28-21420N4665FManzani Kelly · Temecula, CABuilt 1976 · S/N 28R-7635407N4665JBryant Kenneth W · Spring, TXBuilt 1968 · S/N 28R-30563N4665RGaulden Dennis N · Waukesha, WIBuilt 1966 · S/N 28-21421N4666JBodie Charles H · Springfield, ORBuilt 1968 · S/N 28R-30565N4667RAdams Michael S · Huntsville, ALBuilt 1966 · S/N 28-21423N4669FHoese Clinton M · Spring Branch, TXS/N 28-7725026N4669JAirlake Aero Inc · Lakeville, MNBuilt 1968 · S/N 28R-30569N466FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020066N4671JBoklage Garnett H · Torrance, CABuilt 1968 · S/N 28R-30571N4671RRudder Burt H · Alamo, NVBuilt 1966 · S/N 28-21428N4672JBallard Shu Hui · Rancho Cucamonga, CAS/N 28R-30573N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576
Back to AD 87-08-08 R3