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.

N678HCMckisson Holdings LLC · Renton, WABuilt 1980 · S/N EA-180N678JInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N TH821N678JREberhardt John R Jr · Katy, TXBuilt 1977 · S/N D-10095N67901Fly Safe Partners LLC · Sugar Land, TXBuilt 1984 · S/N E-2135N6791KJj&R A36 Inc · Moosic, PABuilt 1984 · S/N E-2136N67971Trophy Holding LLC · Ocoee, FLBuilt 1984 · S/N TH-1408N6797YFar West Ranches Inc · Brawley, CABuilt 1995 · S/N E-2974N679APMilam James J · Lampasas, TXS/N E-679N67ALAlan Gaudenti · Groveland, CABuilt 1988 · S/N E-2420N67CDAspen Aircraft LLC · Oklahoma City, OKS/N E-2554N67DRLarson Jeffrey · Spearfish, SDS/N D-9772N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43N67JWManley Steven T · Dallas, TXS/N E-1530N67LRoad Kill Aviation Inc · Wilmington, DEBuilt 1973 · S/N TE-908N67TA2planks LLC · Newark, DEBuilt 2002 · S/N E-3478N6801SMastropole James W · Great Falls, VABuilt 1976 · S/N D-9849N6801THoffman Peter · Monrovia, CABuilt 1984 · S/N EA-429N6808SKlw Flight Management LLC · Booneville, MSS/N D-9852N6810SUsda-Aphis-Ppq · Edinburg, TXBuilt 1975 · S/N TH-691N6816SHodges Seth L · Omaha, TXBuilt 1976 · S/N E-810N6821SSouthern States Aircraft LLC · Walland, TNBuilt 1976 · S/N D-9853N6829WGroupe Caraibe LLC · Wilmington, DEBuilt 1984 · S/N EA-407N6831SJordan David N Jr · Knoxville, TNBuilt 1977 · S/N D-9971N6834APlum Family Buildings LLC · Marengo, IABuilt 1984 · S/N EA-408N6837QLa Brada Fabio · Decatur, TXBuilt 1984 · S/N E-2143N683SDMurray Steven L · Webster, NYBuilt 1980 · S/N EA-148N6848CRegistration Pending · Sheridan, WYRegistration pendingBuilt 1984 · S/N E-2147N684WTMaxwell Duane T Trustee · Visalia, CABuilt 1979 · S/N E1533N685TBYankee Flyers Inc · Mount Vernon, IABuilt 1973 · S/N E-469N6860LPrevost Christopher D · Sonoma, CABuilt 1984 · S/N TH-1410N6861PFullerton Robert D · Houston, TXS/N EA-686N686FRVon Syke Orchards LLC · Anderson, SCBuilt 1979 · S/N TH-1015N686MEMachined Fixture Fabrication LLC · Burnsville, MNS/N E-3593N6878LMurawski Todd · Port Austin, MIBuilt 1988 · S/N CE1279N687SAGerstein Lee · Park City, UTBuilt 2001 · S/N EA-687N688MLeading Edge Aviation Inc · Bend, ORBuilt 1972 · S/N CE-391N689ABCharney Air Inc · Wilmington, DES/N E2513N689CAir Mt A36 LLC · Lake Havasu City, AZBuilt 2002 · S/N E-3461N68BBKorney Eugene A Trustee · Los Angeles, CABuilt 1981 · S/N TJ-317N68BQUnfinished Journey LLC · Dover, DEBuilt 1978 · S/N TH-952N68CTSilver Arrow LLC · Alvin, TXBuilt 1980 · S/N TE-1174N68JPDocs Aviation LLC · Saint Peters, MOS/N TE-854N68MMLetters Inc · Santa Maria, CABuilt 1979 · S/N EA-5N68MP920 Redmond Leasing LLC · Wilmington, DEBuilt 1986 · S/N E-2320N68RTWrye David · Kevil, KYBuilt 1991 · S/N CE1629N691JHSb Airlines Inc · Wilmington, DEBuilt 1985 · S/N TJ-480N6921CU S Helicopters Inc · Marshville, NCS/N E-2080N6925BElkin Aviation LLC · State Road, NCBuilt 1985 · S/N E-2258N6926RFahs Jon R Jr · Nokomis, FLS/N EA-436N69279Alexa Enterprises LLC · Indianapolis, INBuilt 1984 · S/N EA-413
Back to AD 87-18-06 R1