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.

N94DZHigh Desert Aero Holdings LLC · Portland, ORS/N 90718N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053N94FDBeaver Jonathan D · Greensboro, NCBuilt 2002 · S/N 81243N94GCCook Gregory L · Carl Junction, MOBuilt 1994 · S/N 20020CN94GWJ & J 327 LLC · Clare, MIBuilt 2001 · S/N T18208018N94HFDefenbaugh Matthew J · Biggsville, ILBuilt 1979 · S/N 1153-79N94HHHarris Hill Soaring Corp · Horseheads, NYBuilt 1969 · S/N 25-4331N94HJGable Taylor Lee · Nicholson, GABuilt 1975 · S/N 17265633N94HUTronstad John L · Baker, MTBuilt 1994 · S/N 1260N94HWLach John F · Warren, OHBuilt 2002 · S/N 90045N94HYWest Metro Aviation LLC · Buffalo, MNBuilt 2005 · S/N 2297N94KBBaker Bryn M · Clinton, UTBuilt 2000 · S/N 23929N94KDSprik Robert J · Hamilton, MIBuilt 1995 · S/N KD-03N94KKKokemiller Kelley M · Boone, IABuilt 2010 · S/N 91678N94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026CN94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029CN94LESky Path N94le LLC · Carmel, INBuilt 1993 · S/N 20776N94LJFrostenson Bobi J · Fairfield, IDBuilt 1986 · S/N 218N94MBReese Elizabeth J · Glade Park, COBuilt 2012 · S/N 1306N94MPMissouri State Highway Patrol · Jefferson City, MOBuilt 1998 · S/N 18280271N94PLucas Matthew A · Mission Viejo, CABuilt 1969 · S/N 32-40660N94PKAshwill Gregory L Trustee · Overgaard, AZBuilt 2012 · S/N 90050N94RTRoholt Philip C · Canton, OHBuilt 2014 · S/N 1N94SBBernatz Gerald F · Highland, ILBuilt 1994 · S/N 22194N94SJMoe Alan D · North Bend, ORBuilt 1988 · S/N 01N94TBMartin Robert L III · Covesville, VAFirst renewal noticeBuilt 1995 · S/N 23882N94TDKirk Tim L · Hilltop Lakes, TXBuilt 2007 · S/N 71717N94TFWildblue LLC · Edgerton, MOBuilt 1994 · S/N 3213074N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814N94TWCactus Skybolt Aviation LLC · Athens, ALBuilt 1997 · S/N 049N94VFPenhorwood Joshua M · Shubuta, MSBuilt 1994 · S/N 809N94WAVidal Aviation LLC · Gaithersburg, MDS/N 2843118N94WDRegistration Pending · Sugar Grove, ILRegistration pendingS/N 1849N94WGAltruda Thomas Joseph · Las Vegas, NVBuilt 2005 · S/N 4273N94WSParker Rob · Oklahoma City, OKBuilt 1994 · S/N 3176N94XTaylor Samuel R · Kenai, AKBuilt 1962 · S/N 18-7858N94YCBeauchene Mark J · Des Moines, IABuilt 1965 · S/N 30-899N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775N9500DFlight Club LLC · Anchorage, AKBuilt 1958 · S/N 22-6415N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620N9500LAtlantic Aero Club Inc · Newark, DEBuilt 1972 · S/N AA5-0100N9500MZoom Thusiasts LLC · Smyrna, GABuilt 1967 · S/N 670258N9500WRachel Calvin · Kimberly, ALS/N 28-22921N9501DBelof Joshua · Franklin, NCBuilt 1958 · S/N 22-6416N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621N9501MCasterline Douglas J · Kansas City, MOBuilt 1966 · S/N 670078N9501PThumann Bruce E · Pasadena, TXBuilt 1972 · S/N 24-5018N9501WAwwad Mamdouh A · Walnut Creek, CABuilt 1997 · S/N 17280304N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182
Back to AD 87-10-06 R1