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.

N920GCSabre Drilling Consulting LLC · Summerfield, NCBuilt 1992 · S/N TH-1660N920LGSmart Motion Advisory Group LLC · Frisco, TXBuilt 1994 · S/N E-2901N9212QViking Pilot LLC · Carmel, CABuilt 1971 · S/N E-268N9216QOsage Aviation LLC · Yates Center, KSBuilt 1971 · S/N D-9268N9217QMiyamoto Edward · Rio Vista, CABuilt 1971 · S/N CE-340N9219QMedia Exp LLC · Portland, ORBuilt 1971 · S/N D-9265N921KKTat Networks And Aviation LLC · Bend, ORBuilt 1974 · S/N TE-980N921MJKing Robert Kyle · Wichita Falls, TXS/N CE-1458N921MKCognito Design Inc · Punta Gorda, FLS/N D-9321N9221QPhelan Raymond F · Portland, ORBuilt 1971 · S/N D-9264N9223QElling Fred · Tucson, AZBuilt 1971 · S/N CE-350N9225QTh Real Estate Solutions LLC · Bossier City, LABuilt 1971 · S/N CE-343N9226QBelanger Bobby Lee · New Braunfels, TXBuilt 1971 · S/N E-284N922CWAngel Flyers LLC · Charlottesville, VABuilt 1994 · S/N E-2886N922DRAdams Paul · Lake Havasu City, AZBuilt 1989 · S/N CE-1361N922HBPovero Marcus E · Fort Worth, TXBuilt 1977 · S/N TH-825N922LZTmde Calibration Labs Inc · Richmond, MEBuilt 1974 · S/N TE993N9233QMid America Aviation LLC · Wilmington, DEBuilt 1971 · S/N D-9274N9239QRegistration Pending · Bessemer, ALRegistration pendingBuilt 1971 · S/N TH-139N923AKHenderson Alexander · Zephyr Cove, NVBuilt 1971 · S/N E-285N923RLUrquhart Kris · Fallon, NVBuilt 2004 · S/N E3537N9242QSample Donald L · Houston, TXBuilt 1970 · S/N D-9242N9243QFlegler Barry Bronson · Eagle, MIBuilt 1970 · S/N D-9243N924CTGo South LLC · Ruleville, MSBuilt 1979 · S/N CE-889N924KGHairston Hollie Brenton · Bryan, TXBuilt 1979 · S/N E1507N924RBHitendra Chaturvedi · Chandler, AZBuilt 1979 · S/N E-1612N924RHSmith Joelene K · Avon, INBuilt 1978 · S/N E-1288N924VBauman Ronald L · Stuttgart, ARBuilt 1974 · S/N D-9702N924Y924y LLC · Visalia, CABuilt 1998 · S/N E-3198N9253QN9253q LLC · Goldsby, OKBuilt 1971 · S/N D-9253N9257QC9 Aero LLC · Gothenburg, NEBuilt 1971 · S/N E-277N925CPoms Scott H · San Mateo, CABuilt 1977 · S/N E-1057N925MVan Wylen Mary F · Grand Rapids, MIBuilt 1973 · S/N D-9474N925SLInnovative Aviation LLC · Deatsville, ALBuilt 1976 · S/N E-938N925TPKtm Projects LLC · Durant, OKBuilt 1976 · S/N TJ-35N925VVEndicott Properties LLC · Hilton Head Island, SCS/N TJ188N9260QToomey Neal P · Huntington Beach, CABuilt 1971 · S/N CE-348N9262QPrince John Curtis III · Frierson, LABuilt 1971 · S/N CE-320N9266QDecastro Susan · Westborough, MABuilt 1972 · S/N TE-861N9268QWeyhmuller Luke · Chapin, SCBuilt 1971 · S/N E-279N926BTTelematic Systems Inc · North Fort Myers, FLBuilt 1977 · S/N TE-1110N9273QFrost Scott · West Palm Beach, FLBuilt 1971 · S/N E-280N9276QSunrise Aeronautics LLC · Punta Gorda, FLBuilt 1971 · S/N CE-342N927AWLambert Contracting LLC · Hollywood, ALBuilt 2001 · S/N E3426N927DCCiruli David E · Lafayette, CABuilt 1976 · S/N D-9855N927JBAirgroup Express LLC · Santa Rosa, CABuilt 1980 · S/N D-10345N927MWStrauss Michael · Ormond Beach, FLBuilt 1973 · S/N D-9546N9282QMsxpert LLC · Sheridan, WYBuilt 1971 · S/N TE-842N9286QDunn Louis · Hampshire, ILBuilt 1971 · S/N E-291N9287QElarel Corporation · Lewes, DEBuilt 1971 · S/N D-9287
Back to AD 87-18-06 R1