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.

N18331Fred Garrison Oil Co · Plainview, TXBuilt 1977 · S/N D-10042N18333Rjb Air LLC · Lexington, KYBuilt 1977 · S/N TE-1093N18334Jones Marine Inc · Salisbury, NCBuilt 1977 · S/N CE-728N18337Urban James G · Panama City, FLBuilt 1977 · S/N D-10047N1833DGeese Jeffrey L · Pray, MTBuilt 1981 · S/N CE-952N1833LScrap Metal LLC · Mountainside, NJBuilt 1977 · S/N CE-721N1833QItb 10721 LLC · Edmonds, WABuilt 1985 · S/N CE-1069N18344Ab Aviation Sales & Rental LLC · Washington, DCBuilt 1978 · S/N TE-1123N1834SMillan Person Aircraft Inc · Austin, TXS/N E-1909N1834WTri-Aero Of Grand Rapids · Ada, MIBuilt 1973 · S/N D-9429N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855N18356N18356 LLC · Hayden, IDBuilt 1977 · S/N E-1101N18358Life Is A Beech LLC · Los Lunas, NMBuilt 1977 · S/N TH-814N1835FMt Explore LLC · Kalispell, MTBuilt 1984 · S/N E-2157N1835SEagles Flying Club Inc · San Francisco, CABuilt 1984 · S/N EA-419N18360Anderson Julie A Trustee · Palo Alto, CABuilt 1977 · S/N TE-1106N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290N18363Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N TE-1105N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854N18367Benoit Farms LLC · Centralia, MOBuilt 1977 · S/N E-1103N18368Olaf LLC · Bellbrook, OHBuilt 1977 · S/N D-10049N18369Barmakian Bruce · San Bernardino, CABuilt 1977 · S/N D-10050N1836BSalt River Dreamers LLC · Santa Rosa Beach, FLBuilt 1985 · S/N E-2270N1836FDe210 LLC · Sandy Springs, GABuilt 1983 · S/N E-2111N1836LFlexjet LLC · Cleveland, OHBuilt 1977 · S/N E-1111N1836ZBrown Farms Inc · Central City, NEBuilt 1981 · S/N CE-970N18378Lodi Airport Maintenance Corp · Las Vegas, NVS/N E-1106N1837LHornby Mark H · New Bern, NCBuilt 1976 · S/N D-9881N1837ZBert Aviation LLC · Clemmons, NCBuilt 1981 · S/N D-10317N18381Texas Aero Services 1 LLC · Frisco, TXBuilt 1977 · S/N CE-732N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121N18396Drec 0419 LLC · Carson, CAS/N TE-1109N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120N18404Cactus Aviation Llp · Gotha, FLBuilt 1977 · S/N E-1122N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437N18429Withers John Justin · Paris, TXS/N CE-937N1842WNorthwoods Aviation · Marion, IAS/N CE-438N18431Stall Benjamin A · Piedmont, OKBuilt 1977 · S/N E-1129N18433J4 Aviation LLC · Lexington Park, MDBuilt 1977 · S/N TK23N1843LRegistered aircraftS/N TJ-65N1844LRao Enterprises LLC · Brighton, MIBuilt 1976 · S/N D-9880N18456Hewson Robert A · Santa Barbara, CABuilt 1977 · S/N E-1131
Back to AD 87-18-06 R1