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.

N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326N3227GOgden Scott S · Collierville, TNBuilt 1995 · S/N E-2927N3227XSasar Inc · Wilmington, DEBuilt 1999 · S/N E-3227N3228WChris I Lee Md Inc · Rowland Heights, CABuilt 1995 · S/N E-2928N3228XN3228x LLC · Colusa, CABuilt 1995 · S/N E-2978N3229GAero-Mark LLC · Winchester, KYBuilt 2000 · S/N E-3329N322ETWing Bird Aviation LLC · Garland, TXBuilt 1975 · S/N TE-1016N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709N322JBJ & R Aviation Inc · Sioux Falls, SDBuilt 1990 · S/N E-2549N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233N3233LMann Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA633N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935N3235TBhatia Kabir · Lake Oswego, ORBuilt 1995 · S/N EA-577N3236GAvan LLC · Lynwood, ILS/N E-2287N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936N3236VMlm Aviation LLC · Saint Francisville, LABuilt 1985 · S/N E-2271N3236ZJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1991 · S/N EA-526N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939N323GBGs Aviation LLC · Lebanon, TNBuilt 1975 · S/N E-647N323KJohnston Darrell · Porter, TXBuilt 1982 · S/N E-1997N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667N323PMSrc Property LLC · Alpine, TXS/N EA-161N323RCTigers Aviation LLC · Wasilla, AKBuilt 1980 · S/N EA-87N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243N3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CABuilt 1995 · S/N EA-575N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746N3246RRegistered aircraftBuilt 1995 · S/N E-2946N3247PCary Leasing & Management LLC · Boerne, TXBuilt 1999 · S/N EA-647N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249JSelge Leasing Inc · Niles, MIS/N E-3349N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909N3251WCorporate Flight Mangement LLC · Dallas, TXBuilt 1995 · S/N EA-576N3252JBas Part Sales LLC · Greeley, COS/N E-3252N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952
Back to AD 87-18-06 R1