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.

N3083JPrivate Jet Solutions LLC · Prior Lake, MNBuilt 1988 · S/N CE-1242N3084MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1988 · S/N EA-480N3084NLaprelle James L · Placitas, NMBuilt 1988 · S/N CE-1246N3084ZMather Clay · Orange Beach, ALBuilt 1988 · S/N E-2426N3085FA To Z Endeavors LLC · Leawood, KSBuilt 1987 · S/N E-2396N3085KBennett Ross G · Eustis, FLBuilt 1987 · S/N E-2401N3085WFly Rudolf Corp · Wilmington, DEBuilt 1973 · S/N TE-954N3086KRicotta Tom · Yuma, AZBuilt 1988 · S/N E-2406N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398N3089HWilliamsburg Air Service Inc · Kingstree, SCBuilt 1988 · S/N CE-1219N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402N308ABLift Time III LLC · Cincinnati, OHS/N E-3533N3090PRegistered aircraftBuilt 1987 · S/N CE-1107N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556N3096TBakamis Joel Alexander · South Lake Tahoe, CABuilt 1988 · S/N CE-1208N3096WPickering Paul S · Granbury, TXBuilt 1994 · S/N CE-1786N3097WYarbrough G Mark · Sandia Park, NMBuilt 1973 · S/N CE-473N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076N30KDHolmander John D · East Greenwich, RIS/N E-3502N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122N30LLSoftware Innovations LLC · Wahoo, NEBuilt 1982 · S/N TJ-391N30MKKelly Michael E · Cumberland, RIBuilt 1981 · S/N CE-989N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050N30SLAppel Neal C · Prescott, AZBuilt 1972 · S/N E-338N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74N30VMKnott Richard C · Stony Brook, NYBuilt 1973 · S/N CE-453N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439N30WGMather Christopher D · Hayward, CABuilt 1974 · S/N TE-997N3100BLeone James Frank · Cotulla, TXBuilt 1994 · S/N CE-1789N3101WGeorge Jon A · Durango, COS/N TE-953N3102CD & D Motors LLC · Georgetown, TXBuilt 1987 · S/N CE-1179N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558N3105WDavis Kenneth D · Ft Wayne, INBuilt 1973 · S/N E-494N3106DSouth Delta Aviation Inc · West Helena, ARBuilt 1988 · S/N CE-1215N31074Hale Aviation Inc · Saint Augustine, FLBuilt 1988 · S/N CE-1210N31075Camden Group Inc · Boston, MABuilt 1988 · S/N E-2415N3108LWickersham Brian L · Council Bluffs, IABuilt 1988 · S/N CE-1248N3108NBartlett Paul H · Nebo, NCBuilt 1988 · S/N CE-1218N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534N310TVHaushold Aviation LLC · Shelbyville, TNBuilt 1978 · S/N E-1340N3111DMonarch Air Services LLC · Ballwin, MOBuilt 1994 · S/N E-2874N3111HMcniel George A · Portland, ORBuilt 1987 · S/N CE-1168
Back to AD 87-18-06 R1