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.

N6928BChristian Robert D · Owasso, OKBuilt 1984 · S/N E-2150N6928RZeroth Law Aviation LLC · Fitchburg, WIBuilt 1984 · S/N E-2151N6929BBantam Vision Inc · Monte Vista, COBuilt 1984 · S/N EA-414N692SABob Hannah Aviation LLC · Caldwell, IDS/N EA-692N6930CSix26 Aviation LLC · Freeport, FLBuilt 1984 · S/N EA-420N6930SBurbach Paul J · Waukesha, WIBuilt 1984 · S/N EA-421N6930XMcconville Richard E · Indianola, NEBuilt 1984 · S/N CE-1037N6931TSmith John D · Johnson, KSBuilt 1984 · S/N E-2167N693BHRed River Cellular Telephone Corp · Texarkana, ARBuilt 1980 · S/N TJ-294N695TClay Kennamer Livestock Farms LLC · Hollywood, ALBuilt 1976 · S/N TK-3N696BTSanta Anita Inc · Dallas, TXBuilt 1974 · S/N CE-515N696MCHay Robert G · Point Arena, CABuilt 1990 · S/N CE-1476N696WHGarnett Charles Wade · Hopkinsville, KYS/N E-3048N6999N3v1 LLC · Pensacola, FLBuilt 1975 · S/N D-9815N699BBProfi-Vision Inc · Fogelsville, PABuilt 1981 · S/N TJ-334N699PSMcmillen Yachts Inc · Newport, RIBuilt 1998 · S/N TH1856N69BVJaguar Technologies Inc · Stanberry, MOS/N E-911N69CLTspy Services Inc · Nicholasville, KYBuilt 2000 · S/N TH-1949N69CTEan Aviation Inc · Clarendon Hills, ILBuilt 1977 · S/N CE-718N69GDBonanza Five Flying Club Inc · Roswell, GABuilt 1989 · S/N E-2509N69LCConsol Air Inc · Youngsville, NCS/N TJ-438N69LJGonzalez-Ceballos Lorena Isabel · Haw River, NCS/N D-9692N69TFObryan Michael R · Louisville, KYBuilt 1990 · S/N CE-1525N69WSHurricane Joaquin LLC · Umatilla, FLS/N TH-780N69XGHahn Curtis D · Saint George, UTBuilt 1976 · S/N D-9859N69YGGaudenti Alan · Groveland, CABuilt 1987 · S/N CE-1189N6BYDac Aero LLC · Jacksonville, FLBuilt 1991 · S/N TH-1629N6CHHodge Cleophas U · St Thomas, VIBuilt 1971 · S/N TH-131N6DHHackler Dane · Hemet, CABuilt 1972 · S/N CE-397N6ED3 Rivers Inc · St George, UTS/N TJ-9N6FBTotman Darwin L Jr · Montgomery, LABuilt 1978 · S/N E-1318N6GFFrodel Greg W · Pasco, WABuilt 1991 · S/N E-2657N6JCRaa Investments LLC · Albertville, ALBuilt 1982 · S/N CE-994N6JTBandy Steven Trustee · Marana, AZBuilt 1979 · S/N E-1565N6LS9 Seconds Consulting LLC · Wellington, FLBuilt 1981 · S/N TE-1186N6MZWalters Glenn L · Triadelphia, WVBuilt 1988 · S/N CE-1244N6THDouble I Flyers Inc · Wilmington, DEBuilt 1974 · S/N D-9622N6VUPro Motive LLC · Glade Spring, VABuilt 1975 · S/N TH-665N6WKSushi Aviation Holdings LLC · Raleigh, NCBuilt 1976 · S/N E-807N6WWWintons Wings LLC · Bardstown, KYBuilt 1973 · S/N TH-358N6XZKahler Automation Corp · Fairmont, MNBuilt 1982 · S/N E-2047N6ZMStauf Air LLC · Germantown, TNBuilt 1990 · S/N E-2574N700DCSwanson David R · Isanti, MNBuilt 1977 · S/N E-1132N700EDMcd Aviation Inc · Wilmington, DEBuilt 1972 · S/N D-9372N700KBrenner Gary Lynn · Mission Viejo, CABuilt 1981 · S/N TH-1321N700RCUniversal Aviation LLC · Decatur, ARBuilt 1991 · S/N E-2606N700SSBullard Franklin C · Ormond Beach, FLS/N E-1248N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194N7014CAct Aviation LLC · Oxford, MSBuilt 1979 · S/N CE-883N702DDJoyce Consulting LLC · Black Hawk, SDBuilt 1999 · S/N EA-644
Back to AD 87-18-06 R1