OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N82964Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1761N82966Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1757N8296LRoth Vicki B · Bristow, OKBuilt 1993 · S/N E-2833N8296RPowell Franklin Travis · Lone Pine, CABuilt 1992 · S/N E-2763N8296UFritzinger Mark Thomas · Goldsboro, NCBuilt 1993 · S/N E-2828N8297ABonanza A36 LLC · Cedar Rapids, IABuilt 1992 · S/N E-2764N8298HC & L Leasing LLC · Cody, WYBuilt 1993 · S/N CE-1741N8299DB K A Air LLC · Kennett, MOS/N E-2812N8299GHoughtaling Richard P · Harwich, MABuilt 1993 · S/N CE-1749N8299WKj 422 LLC · Augusta, GABuilt 1993 · S/N E-2809N8299ZCoachair Inc · Groveland, CABuilt 1993 · S/N EA-545N82BVetted Air LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2663N82BFMorrison James M III · Terry, MSBuilt 1981 · S/N E-1937N82CFKehler Kelly · Saint Xavier, MTBuilt 1975 · S/N TE-1061N82CKBloxham Thomas L · Pleasant Hill, CABuilt 1997 · S/N E3096N82HCVan Buskirk Steven · Denver, COBuilt 1974 · S/N D-9584N82LBLakeland Aircraft Maintenance LLC · Lakeland, FLBuilt 1978 · S/N TH-910N82UCMajesty Air Inc · Wilmington, DEBuilt 1972 · S/N TH-276N83000Gehrer Aviation LLC · Wichita, KSBuilt 1993 · S/N E-2829N8300ZWillowridge Farm · Winchester, KYBuilt 1993 · S/N EA-551N830CCCreson John L Jr · Augusta, GABuilt 1970 · S/N TH-31N830SUJames John S · Perkins, OKBuilt 1978 · S/N TE-1126N830TDWhite And Blue LLC · Auburn, CABuilt 1987 · S/N E-2397N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279N831RMBarber John R Trustee · Port Orange, FLS/N E-1685N832HFalkenthal Robert J · Beaumont, CABuilt 1977 · S/N E-1047N832RSHaps Shack Express LLC · Asheville, NCBuilt 1978 · S/N E-1345N833Dick David W · Roseburg, ORBuilt 1988 · S/N CE-1217N8338HBayviewer LLC · Sarasota, FLS/N EA-399N833PBSoutheast Flyers LLC · Jackson, MOBuilt 1986 · S/N E2338N833PMLonely Luggage Delivery Inc · Arroyo Grande, CABuilt 1979 · S/N CE-857N833TDTdu Investments LLC · Lewiston, IDBuilt 1998 · S/N CE766N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153N836EVoss Danielle · Dover, NHBuilt 1982 · S/N E-2059N836JBReis James C · Lake Ozark, MOBuilt 2000 · S/N E3312N836LGFly A36 LLC · Browntown, WIBuilt 2001 · S/N E-3405N836TPSale Reported · BristolSale reported, pending cancellationBuilt 1984 · S/N E-2124N837EGZachariah Craig Powell · Salina, KSS/N E-2467N837MLBombero Aviation LLC · Childress, TXBuilt 1994 · S/N EA558N83AVEllis Andrew N · Cocoa Beach, FLBuilt 1983 · S/N TH-1385N83CTFeliz Belize LLC · Pinetop, AZS/N E-370N83GGCec Aviaiton Services LLC · Windsor, CABuilt 1983 · S/N E-2101N83KKLowe Aviation Co · Macon, GABuilt 1996 · S/N TH-1781N83KPMulligan Gary · Kingston, NYBuilt 1990 · S/N CE-1435N83RGKattchee Phillip A · Chappell Hill, TXBuilt 1987 · S/N CE-1205N83WTTurrentine Mark W Md · Indianapolis, INBuilt 1993 · S/N E-2802N841TWMorton Mark H · Granbury, TXBuilt 1994 · S/N E2881N841ZSSilver Stephen E · Cincinnati, OHBuilt 1979 · S/N CE841N842BESparrow Holdings LLC · Irvine, CABuilt 1984 · S/N EA-432
Back to AD 87-18-06 R1