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.

N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N3260FGilbert Aviation Inc · Wilmington, DEBuilt 1995 · S/N TH-1760N3261CHeyman Steven · San Mateo, CABuilt 1996 · S/N TH1785N3262XDns Aviation LLC · Fulton, CABuilt 1995 · S/N E-2962N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301N3269HEom LLC · Little Rock, ARBuilt 1996 · S/N E-2999N326KB4 Wingmen LLC · Sandy, UTBuilt 1973 · S/N CE-422N3270JBerry Matthew G · Creedmoor, NCBuilt 1996 · S/N TH-1770N3270RMotorman Of America Corp · Wilmington, DEBuilt 1995 · S/N E-2970N3271GPettit James P · Newport, VABuilt 1995 · S/N E-2971N3272VWooldridge Homes LLC · New Haven, KYBuilt 1995 · S/N E-2972N327BLCinotto Robert L · Rhome, TXS/N TE-1043N327ESeager Carl E · Greensboro, NCBuilt 1977 · S/N CE-733N327GSkysix Aircraft Management LLC · Saginaw, MIBuilt 1994 · S/N E-2910N3281KWallace Architects LLC · Columbia, MOBuilt 1979 · S/N TH-1006N328HHGeorge James W · Tullahoma, TNBuilt 1992 · S/N E-2752N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269N328MN328m LLC · Marion, INBuilt 2001 · S/N TH-1992N328PStrother J Barron · Santa Rosa Beach, FLBuilt 1999 · S/N TH-1916N329CBullard Aviation Services Inc · Ormond Beach, FLBuilt 1973 · S/N CE-444N329JHAlliance Aircraft Sales Inc · Pierre, SDBuilt 1976 · S/N E-870N329MAfd Aviation LLC · Dallas, TXS/N E-3490N329RTRegistered aircraftBuilt 1972 · S/N D-9343N32BHBechtold Brahm Hellman · Parker, COBuilt 1977 · S/N D-10046N32BLHeiser And Associates Inc · Novato, CABuilt 1982 · S/N EA-296N32DERatcliff Daniel Trustee · Austin, TXBuilt 1977 · S/N D-9965N32NBSteele Kathleen N · Scottsdale, AZBuilt 1990 · S/N CE-1514N32TBBoyland Todd · Solon, OHBuilt 1980 · S/N EA-77N32WHEagle Air Partners LLC · Bartlett, TNBuilt 1977 · S/N E-1184N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869N330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALBuilt 1992 · S/N CE-1707N330GTStaub Gerald J · Tavernier, FLBuilt 1986 · S/N E-2349N330WH2k Partners LLC · Dallas, TXBuilt 1989 · S/N CE-1322N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691N331SASunlight Aviation LLC · Anchorage, AKS/N E-3301N3321CAviation Management II LLC · Des Moines, IAS/N E-1261N332CBFlying Pigs Aviation LLC · Los Altos, CABuilt 2000 · S/N E-3306N332HPDolan Charles A · Augusta, GABuilt 1990 · S/N CE1508N3330MMaine Instrument Flight · Augusta, MEBuilt 1979 · S/N TH-1031N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140N3333AReese Ronald R · Lakewood Ranch, FLBuilt 1977 · S/N E970N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553
Back to AD 87-18-06 R1