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.

N456ADStafford Arthur · Oak Bluffs, MABuilt 1996 · S/N E-3026N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378N456KPNorthern Arizona Renal Aviation LLC · Flagstaff, AZBuilt 1991 · S/N CE-1597N456KWQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N TJ-427N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712N457BKForty Sixty Two B Inc · Lubbock, TXS/N TH-2028N457DFUsda Forest Service Fepp · Mcclellan, CABuilt 1982 · S/N TH-1354N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808N4584SAd Astra Aviation LLC · Shawnee, KSBuilt 1975 · S/N E-751N4585MCorman Bruce D · Burlington, COBuilt 1978 · S/N E-1239N4585SValiair Limited Company Trustee · Casper, WYBuilt 1975 · S/N E-752N4586SEjh Teton Properties LLC · Petaluma, CABuilt 1975 · S/N D-9809N4587SSims Chad L · Marshall, TXBuilt 1975 · S/N E-753N4588APlane LLC · Shady Shores, TXBuilt 1970 · S/N TE-810N458CTAratow Michael · Mountain View, CABuilt 2000 · S/N EA-661N458DGIron Street Aviation LLC · North Kansas City, MOBuilt 1973 · S/N TH-296N458EABeach Boyz LLC · Saint Petersburg, FLS/N E3558N458GLIowa Great Lakes Flyers Inc · Cheyenne, WYS/N TH-1376N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037N458KAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N TH-452N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812N4596SWaters Mark N · Clovis, NMS/N CE-685N4597STopflight Air LLC · Dunkirk, INBuilt 1975 · S/N E-757N4598MRegistered aircraftS/N D-10121N459JDWilson John K · Rosamond, CABuilt 1970 · S/N E-210N459TCN459tc LLC · Wray, COBuilt 1972 · S/N D-9328N45BLKing Air LLC · Sterling, COBuilt 1980 · S/N EA-101N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739N45LCBelle Robert M · Tampa, FLBuilt 1979 · S/N E-1600N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384N45PLLep Holdings LLC · Sheridan, WYBuilt 1987 · S/N CE1167N45PTCleaver Anthony M · Boulder, COBuilt 1976 · S/N TH-727N45USFlight Operations LLC · Hollister, MOBuilt 1977 · S/N CE-722N45WWHolmes Bruce Arthur · Maricopa, CABuilt 1977 · S/N E-1203N4600SCozzolino Aerosports II LLC · Indianapolis, INBuilt 1975 · S/N E-771N4604AThomas Douglas E · Grove City, PABuilt 1970 · S/N E-216
Back to AD 87-18-06 R1