AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N7500WGajewski Richard G · Naples, FLBuilt 1963 · S/N 28-1413N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246N7501FStafford Tech Inc · Rehoboth, MABuilt 1969 · S/N 204N7501JSholl Douglas Alan Jr · Williams, AZBuilt 1968 · S/N 28R-30864N7501WTide Pools LLC · Tucson, AZBuilt 1963 · S/N 28-1406N75021Miller Mariemma L · Martinsburg, PABuilt 1976 · S/N 28-7625192N7502DFlight Lead LLC · Casper, WYS/N 22-5229N7502JIrvin H Hugh · Salina, KSBuilt 1968 · S/N 28R-30866N7502RStapleton James W Jr · Nebo, NCBuilt 1966 · S/N 28-22058N75034Rpm Aviation LLC · Hillsborough, NCBuilt 1976 · S/N 32R-7680248N75039Mulligan Peter · Richardson, TXS/N 28-7615237N7503PHouseth Timothy C · Hastings, MNBuilt 1961 · S/N 24-2704N7503RQuinn George B · Ponce, PRBuilt 1966 · S/N 28-22059N7503SStout Joel D DBA · New Cumberland, PAS/N 61-0066-122N7503WAscend Aviation LLC · Bountiful, UTBuilt 1965 · S/N 28-2903N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565N75046Esson Michael · Durand, MIS/N 28R-7635261N75047Dunlop Vance Trustee · Keizer, ORBuilt 1976 · S/N 28-7690285N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690286N75049Christie Brian L · Irvine, CABuilt 1976 · S/N 28-7690287N7504SAirczar LLC DBA · Corpus Christi, TXBuilt 1987 · S/N S1260N7504WThompson Reese F · Lake Stevens, WABuilt 1965 · S/N 28-2905N75050Delaware State University · Dover, DEBuilt 1976 · S/N 28R-7635262N75055Registered aircraftBuilt 1976 · S/N 28-7625196N75056Warwick Kenneth Robert · Estill Springs, TNBuilt 1976 · S/N 28-7615242N75057Gunter Jerry L Sr · Huntersville, NCBuilt 1976 · S/N 28-7615243N75058Russell K C · Lindsay, CABuilt 1976 · S/N 28-7615244N75059Markiewicz Mark J · Kokomo, INBuilt 1976 · S/N 28-7690289N7505DCronan Joseph M · Santa Maria, CABuilt 1957 · S/N 22-5232N7505RMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 28-22061N75068Kinzie Industries Inc · Erie, COExpired dealerBuilt 1988 · S/N S1323N7506NMeshoppen Air LLC · Tunkhannock, PABuilt 1988 · S/N S1305N7506RGleason Joseph G · Gainesville, FLBuilt 1966 · S/N 28-22062N7506ZStuder Al C · Shelby, MIBuilt 1965 · S/N 25-3538N75070Mansfield Heliflight Inc · Milton, VTS/N S1404N75078Gibson Elizabeth Grace · Hamilton, NJBuilt 1976 · S/N 28-7615246N7507CBlair & Son Inc · Fleetwood, PABuilt 1988 · S/N S1349N7507GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3240N7507MWeststar Ventures LLC · Cannon Falls, MNBuilt 1989 · S/N S1365N7507NKinzie Hon · Anchorage, AKBuilt 2002 · S/N 3321N7507RPanko Douglas A · Minooka, ILFirst renewal noticeBuilt 1966 · S/N 28-22063N7507SBlue Sky Aviation Inc · Texico, NMBuilt 1970 · S/N 61-0068-126N7507USierra Sky Aviation LLC · Kalispell, MTBuilt 1989 · S/N S1393N7507XGhgk LLC · Myrtle Beach, SCBuilt 2002 · S/N 1218N75080Dix Jeffrey G · Wausau, WIBuilt 1976 · S/N 28-7615247N75082Up And Away Aviation LLC · Poughkeepsie, NYBuilt 1976 · S/N 28-7690290N75084Wadas Burton J · Hudson, NHBuilt 1976 · S/N 28-7690292N7508HSons Aviation LLC · Moody, ALBuilt 1992 · S/N S1628N7508LBruegger Shannon B · Lance Creek, WYBuilt 1989 · S/N S1417N7508RTaylor Devan A · Overland Park, KSBuilt 1966 · S/N 28-22065
Back to AD 87-10-06 R1