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.

N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672N26865Coastline Bonanza LLC · Bedford, NHBuilt 1986 · S/N E-2319N268EAAir Ally Asset Management LLC · Chisago City, MNS/N E-3476N268RKalhart Transportation Services Inc · Rancho Santa Fe, CABuilt 1977 · S/N E1092N2690AHamons Jeffery W · Perrysburg, OHBuilt 1978 · S/N E-1264N2693KKelman Naomi · Nashville, TNBuilt 1980 · S/N CE-820N269EAAviar Io LLC · Parker, TXS/N E-3472N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998N26BRStender Aviation B LLC · Huntsville, ALBuilt 1983 · S/N E-2072N26CSJetswiss LLC · Overland Park, KSBuilt 1993 · S/N E-2814N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N26JJCrescenzo David G · Hammonton, NJBuilt 1975 · S/N TE-1058N26PVWoods H Ross · El Dorado, ARBuilt 1971 · S/N CE-347N26QRSolesbee Nathan Arthur · Anaheim, CABuilt 1979 · S/N EA-19N26RGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1987 · S/N E-2383N26RTInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N CE-1292N26URDartswift Inc · Philadelphia, PABuilt 1988 · S/N CE-1274N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406N270KFirst Gear Inc · Fort Wayne, INBuilt 1989 · S/N CE-1386N27117Chalfant William Paxson III · Concord, NCBuilt 1979 · S/N E-1416N271EARichardson Cotton Inc · Wilmington, DES/N E-3486N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229N2730RRp Aviation Inc · Alliance, OHBuilt 1978 · S/N CE-792N273EADavis Jonathon W · Charlotte, NCBuilt 2003 · S/N E3497N273PSBlack James F · Sister Bay, WIBuilt 1972 · S/N CE-379N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113N274HSWebb Alan J · Medford, ORBuilt 1976 · S/N D-9922N274SLHowden Frederick M · Coronado, CAS/N E-2994N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206N275EASmith Mark K DBA · Hubertus, WIS/N E-3520N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376N2764AMorse-Ellington Bruce P · Phoenix, MDBuilt 1986 · S/N E-2322N2773WStokes Robert A · Golden, COBuilt 1975 · S/N D-9720N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029N278CRRittgers Timothy · Lapeer, MIBuilt 1986 · S/N CE-1089N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N278RHolliday Henry S · Poplarville, MSS/N E-1181N2798PNautilus Air LLC · Omaha, NEBuilt 1986 · S/N E-2337N27DHMcavoy Sean M · Greenbrier, TNBuilt 1970 · S/N D-9149N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228N27HBBalk Christopher T · Arlington, WABuilt 1977 · S/N E-999N27LHStavros Andrew · San Jose, CABuilt 1972 · S/N E-375
Back to AD 87-18-06 R1