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.

N33JSBroughton Corp · Newtown Square, PABuilt 1976 · S/N CE664N33KKMcguiness Construction Inc · Ramona, CABuilt 1990 · S/N E-2528N33KSMeggers Roger D · Baker, MTBuilt 1987 · S/N CE-1142N33LPA&H Services LLC · Danville, GAS/N E-1787N33MKFessele Martin · Bridgewater, NJBuilt 1990 · S/N CE1478N33MUKteg LLC · Bridgeport, TXBuilt 1993 · S/N CE-1742N33MY3 Wings LLC · Highland, MIBuilt 1987 · S/N CE-1160N33PESunset Enterprises LLC · Jonesville, VAS/N TE-1018N33PMKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1977 · S/N TJ-78N33RMTrivisonno Dominick P · Skaneateles, NYBuilt 1978 · S/N CE-776N33SFRoseville Aviation LLC · Roxboro, NCBuilt 1972 · S/N TH-190N33SGMennella James E · Oklahoma City, OKBuilt 1980 · S/N EA-109N33SHDrl Baron LLC · San Augustine, TXBuilt 2001 · S/N TH-2007N33TDLightning 35 Aviation LLC · Wilmington, DEBuilt 1973 · S/N CE-415N33TNThree Six Bonita LLC · Georgetown, TXBuilt 1990 · S/N CE-1487N33UBStubbs Thomas A · Knoxville, TNBuilt 1990 · S/N CE-1496N33VBVb313 LLC · Fort Myers, FLBuilt 1976 · S/N D-9899N33VHRegistered aircraftBuilt 1975 · S/N D-9803N33VSRare Eagle Aviation LLC · Westcliffe, COBuilt 1977 · S/N D-10071N33WHBarkley Daniel L · Denton, TXBuilt 1980 · S/N E-1759N33WKSager Earl Dwayne · Perryton, TXBuilt 1979 · S/N TJ-243N33YMDiedrich William Walter · Firebaugh, CABuilt 1979 · S/N CE-840N33ZXLisi Richard A · Palm City, FLBuilt 1976 · S/N E-920N341UMedic Choppers LLC · Springdale, ARS/N TE-826N3425PCw Designer Homes Inc · Burnet, TXBuilt 2001 · S/N E-3425N342SHorn Travis L · Clarksville, ARBuilt 1969 · S/N E-189N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N3436ARegistered aircraftBuilt 1970 · S/N TE-795N343ABPonderosa 343 LLC · Richmond, VABuilt 2000 · S/N E-3343N3443Registered aircraftBuilt 1978 · S/N CE-761N344RCHome Perfection General Contractors Inc · Pelham, ALBuilt 1984 · S/N TH-1412N344SRegistered aircraftBuilt 1972 · S/N TH-210N34549Octans Aviation Co · Watertown, SDS/N TK-62N345CFLowery Ron L · Batesville, ARS/N E-2532N345CGHargis James L · Tioga, TXBuilt 1984 · S/N TJ-468N345CRAlbion Aviation LLC · Florence, SCBuilt 1994 · S/N E-2873N345DWalker Benjamin Kelly · Myrtle Beach, SCBuilt 1988 · S/N E-2422N345JHHurst James H · Longview, TXBuilt 1980 · S/N CE910N345PGN345pg LLC · Chicago, ILBuilt 2001 · S/N TH-2016N345URegistered aircraftBuilt 1971 · S/N E-263N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346ENorth Coast Aeronautical LLC · Cleveland, OHBuilt 1984 · S/N EA-409N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N3476AIsaacs Eugene E · Key West, FLS/N CE-294N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125N348TFli Aero Ltd · New Lebanon, OHBuilt 1976 · S/N E-908N349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202N34BRIndustrial Reports Inc · Raleigh, NCBuilt 1981 · S/N CE-946N34DJBrugman Edward J · Hudson, OHS/N CE-483
Back to AD 87-18-06 R1