JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA201709019021Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE LIGHT AT ROW 5E HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA201709049014Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY GALLEY BAR HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR R61A201708300650Battery · inoperativeEMERGENCY LIGHT NEAR L1 DOOR INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERY, OPS CHECKED GOOD IAW AMM 33-50-01.SDR ASAA2017083021769Lens · brokenEMERGENCY LIGHT COVER NEAR THE L1 DOOR FOUND BROKEN. ACFT GROUNDED. INSTALLED A NEW LIGHT COVER.SDR DALA2017083106527Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REINSTALLED THE LENS.SDR REXA2017083000948Light · inoperativeFA EMERGENCY LIGHT DOES NOT ILLUMINATE.SDR YENA201708300719Light · damagedCABIN SEAT MOUNTED EMERGENCY LIGHT AT 1C FOUND TO BE DAMAGED. BENT PIN. R & R THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-19. OPS CHECKED NORMAL.SDR SIMA20170830002Battery · dischargedWHILE PERFORMING PS-1 INSPECTION FOUND NR 4 AND NR 5 FLOOR PROXIMITY EMERGENCY LIGHT STRIPS INOP. REMOVED AND REPLACED NR 3 EMERGENCY BATTERY POWER SUPPLY IAW AMM 33-50-04. OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 79752.SDR AALA201708319001Light · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTS REFLECTIVE TAPE ON FLOOR BY LEFT ROW 17 IS BOWING UP. RESECURED EMERGENCY LIGHTING STRIP TO FLOOR. OPERATIONAL CHECK GOOD.SDR AALA201708319023Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017083116020Cover · unsecureLT OVERWING EXIT SIGN COVER FELL OFF. REINSTALLED COVER PER SIP.SDR AALA201708319017Light · brokenLOWER FLOOR PROX EMERGENCE ESCAPE LIGHT BRACKET BROKEN OFF AT 27C. REPLACED LOWER FLOOR EMERGENCY ESCAPE LIGHT BRACKET AT 25C IAW AMM.SDR JJBA20170830026Bulb · unsecureMID CABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE. SECURED THE BULB, OPS CHECKED SAT.SDR REXA2017083000947Light · looseGALLEY FLOOR REFLECTIVE EMERGENCY STRIP LOOSE, SECURED IAW AMM 20-00-00. ALL CHECKED GOOD.SDR MASA2017083012582Battery Pack · inoperativeNR 2 EMERGENCY LIGHT BATTERY INOPERATIVE. REPLACED THE BATTERY PACK.SDR AALA20170901008Power Supply · no testEMERGENCY LIGHTS OVERHEAD POWER SUPPLY M33400 AT THE L3 DOOR FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170901006Power Supply · no testEMERGENCY LIGHTS OVERHEAD POWER SUPPLY M33405 AT THE L3 DOOR, FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170901005Power Supply · no testEMERGENCY LIGHTS OVERHEAD POWER SUPPLY M33407 AT THE L4 DOOR FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170901004Power Supply · no testEMERGENCY LIGHTS OVERHEAD POWER SUPPLY M33408 AT THE R4 DOOR FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170901003Power Supply · no testEMERGENCY LIGHT OVERHEAD POWER SUPPLY M33424 AT THE L1 DOOR FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR DALA2017083106469Lens · damagedEMERGENCY LIGHT LENS IS DAMAGED. REPLACED THE LENS COVER . OPS CHECKED GOOD, OK FOR SERVICE.SDR RAIA201708290001Battery Pack · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERY PACK POS 1, OPS CHECKED GOOD.SDR HALA2017083000003Sign · unsecureDOOR 3R EXIT SIGN FELL OFF. RE-INSTALLED DOOR 3R EXIT SIGN.SDR AALA201708319021Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. COCKPIT EMERGENCY EXIT SIGN ASSY INOP. REPLACED FLIGHT DECK EMERGENCY EXIT SIGN ASSY IAW MM 33-51-01.SDR AALA201708319019Sign · looseAIRCRAFT WAS NOT GROUNDED. FOUND EXIT SIGN AT DOOR 4L UNSECURED. SIGN WAS REATTACHED PER AMM 33-50-00.SDR AALA201708319010Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT (14WL) FAILED TEST. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-00.SDR AALA201708319005Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT 11C EMERGENCY SEAT MOUNTED LIGHT INOPERATIVE. REPLACED SEAT 11C EMERGENCY SEAT MOUNTED LIGHT PER AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708309019Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN FALLING OFF NEAR 4R. REPLACED EMERGENCY LIGHT ASSEMBLY AFT OF 4R PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170830001Light · inoperativeAIRCRAFT WAS NOT GROUNDED. COCKPIT EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY (EXIT SIGN) PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708319025Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE G3 GALLEY COAT CLOSET DOOR FRAME IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201708309017Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ACROSS FROM THE FORWARD LAVATORY HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-42-00. OPERATIONAL CHECK GOOD.SDR AALA201708309016Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER THE R2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201708309015Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT RIGHT AISLE NEAR FORWARD GALLEY HAS A BROKEN LENS COVER. REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017083116040Cover · brokenAFT EMERGENCY LIGHT SWITCH COVER SPRING BROKEN. R&R COVER PER SIP.SDR SWAA2017083116018Lens · looseLT AFT LAV EMERGENCY LIGHT LENS LOOSE. SECURED LENS PER SIP.SDR UIEA2017083001583Light · missingFLOOR EMERGENCY LIGHT MISSING ON UPPER DECK. REMOVED AND REPLACED THE LIGHT ASSY IAW 33-51-12, OPS CHECKED GOOD.SDR HALA2017082900238Sign · unsecure3R EXIT SIGN FELL OFF. RE-INSTALLED 3R EXIT SIGN.SDR AALA201708309011Housing · brokenEMERGENCY LIGHT OUTSIDE OF THE L38 LAVATORY FOUND BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR DALA2017082906444Battery Pack · inoperativeLEFT AFT OVERWING EMERGENCY SIGN INOPERATIVE. TROUBLESHOOTING FOUND THE LEFT AFT OVERWING EXIT SIGN BATTERY PACK INOPERATIVE IAW AMM 33-51-07. OPS CHECKED GOOD.SDR AALA201708309007Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING AT R4 DOOR. REPLACED EMERGENCY EXIT LIGHT LENS COVER AT R4 DOOR, OPS CK GOOD, IAW AMM.SDR AALA201708309005Lamp · burned outEMERGENCY WINDOW HANDLE LIGHT INOPERATIVE ON BOTH SIDE. REPLACED THE LAMP. ACFT OK FOR SERVICE IAW AMM.SDR AALA201708309002Wire Harness · damagedEMERGENCY LIGHT INOPERATIVE AT ROW 11L. REPLACED THE WIRE BUNDLE BETWEEN LIGHT SOCKET AND FIRST QUICK DISCONNET AT ROW 11ABC IAW AMM.SDR MASA2017082912580Battery Pack · dischargedOH SIGN AND CEILING EMERGENCY LIGHTS INOP. REPLACED NR 2 BATTERY PACK.SDR F3LA2017082900206Battery · failedREFERENCE LOG PAGE 9029000 ITEM 2, EPSU BATTERY CAPACITY CHECK FAILED TEST AT 12WL. REMOVED AND REPLACED BATTERY AT 12WL IN REFERENCE TO AMM 33-38-000-002-A AND 33-51-38-400-002-A. OPS CHECK GOOD.SDR SWAA2017121818461Bulb · inoperativeRIGHT OVERHEAD STOW BIN EMERGENCY LIGHT INOPERATIVE AT ROW 3. R & R BULB IAW AMM.SDR AALA20170912001Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT RECEIVED FOR L4 DOOR REMOTE WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WELS CONTROL UNITS. REMOVED AND REPLACED WELS CONTROL UNIT PER AMM DMC-B787-A-33-51-0SDR A6WA201745262Light · inoperativeSERVICE DOOR FLOOR PROXIMITY EMERGENCY EXIT SIGN DS11LY INOP FWD CABIN. FOUND WIRES FOR GREEN EXIT LIGHT AT SERVICE DOOR AND WHITE EXIT SIGN LIGHT AT SERVICE DOOR SUPP AND PERFORMED OPS CHECK 33-51-00, OPS CHECK GOOD.SDR YENA201708280724Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. CHECKED OK.SDR YENA201708280723Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. CHECKED OK.SDR YENA201708280722Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. CHECKED OK.
Back to JASC 3350