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.

N5462XThomas Jackson Smitih · Baton Rouge, LABuilt 1977 · S/N E-1105N5466RNorthwest Turbine LLC · Spokane, WABuilt 1985 · S/N TJ-497N546CBFlatland Aviation LLC · Satanta, KSS/N E-3489N5471GGlenn William · Hilton Head Island, SCBuilt 1978 · S/N E-1338N549PTGrant P T · Musella, GABuilt 1976 · S/N TH-711N54DGSaffron Aviation LLC · Carrollton, GABuilt 1979 · S/N E-1562N54HLOverbey Michael B · Houston, TXBuilt 1972 · S/N CE-376N54JNDlz Aviation LLC · Ostrander, OHBuilt 1991 · S/N E-2684N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941N54TCK K Stevens Publishing Co · Astoria, ILBuilt 1976 · S/N CE-661N54WMNemensky Jack · Southborough, MABuilt 1976 · S/N CE-657N5500FVernon Walter Benson · Denver, COBuilt 1989 · S/N CE-1400N550AFAtm One Inc · Tulsa, OKBuilt 1979 · S/N EA-6N550CBCarnevale Philip A · Lake City, FLBuilt 1978 · S/N TE-1135N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505N550JRUrban Cowboy Aviation LLC · Richland, NEBuilt 1990 · S/N CE-1449N550LThompson John S · Dallas, TXS/N CE-1190N550LMAdventure Day Aviation LLC · Greensboro, NCBuilt 1990 · S/N CE-1472N550NCTri-State Communications Inc · South Sioux City, NEBuilt 1988 · S/N CE-1241N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516N550X550x LLC · Tucson, AZS/N D-9255N550YRFriedman Michael S · Chantilly, VABuilt 1981 · S/N TE-1196N5519ABiersack Alexander J · BerlinBuilt 1989 · S/N CE-1337N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519N551BW602 Xx LLC · Springdale, ARBuilt 1990 · S/N CE-1431N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158N551JACalderon Gustave P · Carlsbad, CABuilt 1978 · S/N E 1424N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N5528VTrusler William L · Magnolia, TXBuilt 1990 · S/N CE-1426N5529DKanieski Maximilian M · New Canaan, CTBuilt 1989 · S/N CE-1403N552BBFrench Don Robles · Glendale, AZBuilt 1970 · S/N TE-800N552CKDeep South Management LLC · Douglas, GAS/N TH-2083N552CLWattles Gurdon S · Stuart, FLBuilt 1986 · S/N E2336N552CMCm552 LLC · Katy, TXBuilt 2000 · S/N E-3337N552ZSTuolumne Ridge LLC · Modesto, CABuilt 1983 · S/N EA-343N5530XFaulhaber Orlin W · North Platte, NEBuilt 1989 · S/N E-2504N5531DBas Part Sales LLC · Greeley, COS/N E840N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N5538XBeartooth Air LLC · Cody, WYBuilt 1989 · S/N CE-1373N5546Forster Sebastian Alexander · Elberta, ALBuilt 1979 · S/N EA-53N5546FCe-1382 LLC · Point Clear, ALBuilt 1989 · S/N CE-1382N554DDMhr Holdings LLC · Indian Hills, COBuilt 1973 · S/N TE-943N554TMLamar Aviation LLC · Paris, TXBuilt 1992 · S/N E-2688
Back to AD 87-18-06 R1