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.

N777BVPowell Robert W · Horseshoe Bay, TXBuilt 1971 · S/N TE-829N777CEMiller Dana · Tracy, CABuilt 1977 · S/N D-10019N777CZFunchess Thomas A · Hazlehurst, MSBuilt 1970 · S/N TE-809N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347N777EVSelldorff John · Chatham, MABuilt 1990 · S/N E-2520N777HGProcyon Group Inc · Wilmington, DEBuilt 1975 · S/N E-777N777MMJsgjr LLC · Fife, WABuilt 1997 · S/N EA-597N777MYGraham Elmer R Jr · Graford, TXBuilt 2000 · S/N E-3328N777NKTaylor Jonathan K II · Granbury, TXBuilt 1996 · S/N E-2996N777NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N CE861N777PBWw Build Inc · Deland, FLBuilt 1973 · S/N E-439N777PDIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N D-10380N777QAMabry Kelly · Russellville, ARBuilt 1970 · S/N TH-143N777RABirdsong Michael L · St Simons Island, GABuilt 1981 · S/N TH-1273N777RQSchelde Brian L · Marble Falls, TXBuilt 1973 · S/N TH-298N777SGClaw LLC · Lake Saint Louis, MOS/N TH805N777TKProfessional Paving Services LLC · Macon, GABuilt 1979 · S/N TH-1018N777UPerez Michael Joel D · San Diego, CABuilt 1970 · S/N D-9096N777VBArizona Thunderbolts LLC · Scottsdale, AZBuilt 1992 · S/N EA-539N777WVIndependent Mortgage · Westlake, LABuilt 1996 · S/N TH-1784N777YFLandsgaard Equipment Leasing LLC · Wellington, COBuilt 1989 · S/N E-2495N7788HTeodoro Financial Group Inc · Mill Valley, CABuilt 1988 · S/N E-2436N778FYQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1148N778RWSoutherly Winds LLC · Rogers, ARBuilt 1976 · S/N CE-652N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489N77ACEagle Aviation Consulting LLC · Wilmington, DEBuilt 1991 · S/N E-2675N77BJHint Peter T · Centerport, NYBuilt 1974 · S/N D-9698N77CSRay Charles L · Hayti, MOBuilt 1977 · S/N CE-741N77CYN77cy LLC · Lambertville, MIBuilt 1974 · S/N D-9678N77DADuncan Aviation Inc · Lincoln, NEBuilt 1992 · S/N CE-1649N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N77FHCumbey Joseph S · Scroggins, TXBuilt 1977 · S/N D-10035N77GFSkydancer LLC · Evergreen, COBuilt 1986 · S/N CE-1101N77HCHlh Properties LLC · Cohutta, GABuilt 1998 · S/N E-3189N77HTLac Aero LLC · Liberal, KSBuilt 1978 · S/N E-1324N77JEEngelhardt John L · Netarts, ORBuilt 1977 · S/N E-1080N77KGPickett Ronald K · Orange Park, FLBuilt 1974 · S/N CE-486N77LBEleuthera II LLC · Mesa, AZBuilt 1974 · S/N TH-536N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287N77MDDerby Michael R · Falls Church, VABuilt 1970 · S/N E-234N77MS5foot Face Flight Inc Trustee · Wilmington, DEBuilt 1983 · S/N E-2116N77NWRizor Justin · Phoenix, AZS/N TK-141N77PGJjo Aero LLC · Keller, TXBuilt 1991 · S/N E-2680N77QQBurkhardt Wayne W · Deming, NMBuilt 1979 · S/N D10251N77RTBouchier Thomas B · Post, TXBuilt 1978 · S/N TJ-135N77SMHuberty Gregory N · Billings, MTBuilt 1975 · S/N TE-1023N77VBMorgenroth Aviation LLC · Victoria, TXBuilt 1974 · S/N D-9629N77VKPontiac Flying LLC · Pontiac, ILBuilt 1970 · S/N E-221N77XFDuwane D Skipper · Booker, TXBuilt 1977 · S/N D-9989N77XJDavid L Samani Md Inc · Lincoln, NES/N TH-1993
Back to AD 87-18-06 R1