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 SWAA2017012511451Battery Pack · dischargedRT STOWBIN BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROWS 5 TO ROW 6. R&R BATTERY PACK IAW AMM.SDR SWAA2017012511450Battery Pack · dischargedRT STOWBIN BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROWS 2 TO ROW 3. R&R BATTERY PACK IAW AMM.SDR SWAA2017012511449Light · inoperativeLT OVER WING EMERGENCY EXIT SIGN INOP. R&R BULB IAW MM.SDR RAIA201701240001Light · damagedNR 4 EMERGENCY LIGHT BATTERY KEEPS BLOWING FUSES. REPAIRED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR YENA201701240047Bulb · failedDURING EMERGENCY LIGHT CHECK, FOUND R4 DOOR LOWER EMERGENCY EXIT LIGHT UPPER BULB INOPERATIVE. REPLACED THE BULB IAW AMM 35-51-13.SDR MASA2017012412828Light · inoperativeCEILING EMER FLOOD LIGHT ROW 17 INOP. REPLACED BULB.SDR MASA2017012412827Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED BATTERIESSDR F3LA2017012400067Power Supply · no testEMERGENCY LIGHTING FAILED TEST. REMOVED AND REPLACED THE EPSU 13WL. OPS CHECKED GOOD.SDR DALA2017012400598Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE CABIN DOOR OVERHEAD EMERGENCY EXIT LIGHTS AT BOTH L1 AND L2 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE OPERATIONAL CHECK WAS GOOD.SDR AALA20170125013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170125009Rail · looseAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHT OVER SEAT 24B IS DETACHED DUE TO A LOOSE RAIL. RESECURED EXIT LIGHT RAIL. OPERATIONAL CHECK GOOD..SDR AALA20170125006Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. L1 DOOR WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT BATTERY POWER FAILURE DATA MESSAGE. REMOVED AND REPLACED PRIME CONTROL UNIT IAW DMC-B787-A-33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170123008Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY FLOODLIGHT AT G2 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201701249006Light · dirtyR1 DOOR SLIDE LIGHT INOPERATIVE. MAINTENANCE REMOVED DEBRIS FROM SLIDE LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170124002Marker · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT MARKER LIGHT AT R4 DOOR NEAR FLOOR IS BROKEN. REMOVED AND REPLACED EXIT MARKER IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR SIMA20170123003Charger · failedALL EMERGENCY LIGHTS ON NR 1 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 1 EMERGENCY LIGHT BATTERY AND CHARGER, OP/C GOOD, IAW AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 101808SDR SIMA20170123004Light · inoperativeROW 12 AISLE EMERGENCY LIGHT INOP. REMOVED AND REPLACED ROW 12 AISLE EMERGENCY LIGHT IAW AMM 33-50-08. OPC GOOD.SDR SIMA20170123005Light · inoperativeLAST OVERHEAD EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE. R&R CEILING PANEL EMER LIGHT BULB IAW AMM 33-51-09. FOUND GOOD.SDR SWAA2017012411440Light · inoperativeFORWARD ENTRY DOOR EXTERIOR EMERGENCY SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017012411422Lens · crackedLT EMERGENCY LIGHT LENS COVER CRACKED AT ROW 15. R&R COVER IAW AMM.SDR SWAA2017012411421Lens · looseR1 DOOR EMERGENCY EXIT SIGN LIGHT LENS LOOSE. R&R LENS IAW AMM.SDR SWAA2017012411420Light · looseAFT GALLEY BULKHEAD WALL EMERGENCY EXIT SIGN LIGHT LOOSE. SECURED LIGHT ASSEMBLY IAW AMM.SDR MASA2017012312826Sensor · dirtyEMERGENCY EXIT SIGN MAIN CABIN DOOR INOPERATIVE. CLEANED SENSORSSDR JJBA20170123020Sign · not reportedEMERGENCY EXIT SIGN AT ROW 18. PERFORMED ADJUSTMENT AND TEST ON EMERGENCY EXIT SIGN. OPS CHECK GOOD.SDR JJBA20170123019Light · unsecureEMERGENCY LIGHT IN THE GALLEY NOT SECURE. SECURED EMERGENCY LIGHT.SDR HALA2017012300013Sign · damagedLIGHTED EXIT SIGN ON FWD CABIN CEILING DAMAGED. REMOVED AND REPLACED FWD CABIN EMERGENCY EXIT SIGN CEILING LIGHT PER WDM 33-51-12. OPS CHECKS OK. OFF: PN: BR9065-001 SN: 0012 ON: PN: BR9065-001 SN: 0199SDR DALA2017012300576Battery Pack · inoperativeCEILING EMERGENCY LIGHTS 4DC & 24DC INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED OK. OK FOR SERVICE.SDR CALA2017012300174Battery Pack · malfunctionedEPSU BATTERY RIGHT FAILED A TEST WITH BATTERY FAULT. REMOVED AND REPLACED THE BATTERY PACK, OP CHECKED NORMAL IAW AMM 33-51-38.SDR CALA2017012300173Power Supply · faultedEPSU UNIT AFT L MESSAGE AFTER EMERGENCY LIGHT TEST. PERFORMED A EPSU BITE TEST IAW AMM 33-51-38 SYTEM TESTED OK.SDR CALA2017012300172Power Supply · faultedEPSU UNIT EMERGENCY RT MESSAGE AFTER COMPLETION OF CABIN EMERGENCY LIGHT OPERATIONAL CHECK. REPLACED THE POWER SUPPLY IAW MM 33-51-38, OPS CHECKED GOOD.SDR CALA2017012300170Battery Pack · faultedEMERGENCY LIGHT SYS TEST FAULTED FOR THE EPSU UNIT AND AFT EPSU BATTERY. REPLACED BATTERY PACK, TEST PASSED. IAW MM 33 51 38 000 002A,SDR CALA2017012300168Battery Pack · inoperativeEMERGENCY LIGHTING ON FIRST CLASS SEATS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED OK.SDR MASA2017012312825Light · inoperativeSECOND TO AFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR HNAA2017012300025Bulb · inoperativeFLOOR EMERGENCY LIGHTS ARE INOPERATIVE 4TH AND 20TH FROM FRONT. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR DALA2017012300543Light · inoperativeDURING SERVICE CHECK, FOUND MONUMENT MOUNTED EMERGENCY ESCAPE PART MARKER ON THE RIGHT SIDE OF GALLEY A4 INOPERATIVE. REPLACED EMERGENCY LIGHT.SDR DALA2017012300694Light · malfunctionedEMERGENCY LIGHTS IN AFT CABIN FLASHING WHEN ARMED. RESET THE EMERGENCY LIGHTS IAW MM.SDR DALA2017012400611Guard · defectiveEMERGENCY LIGHT SWITCH TURNS OFF WHEN GUARD IS LOWERED. REPLACED EMERGENCY LIGHT PANEL PER AMM33-51 CKS GOOD.SDR SWAA2017012511464Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201701239013Cover · missingMISSING LIGHT COVER AT 1R DOOR MARKED EXIT. INSTALLED EMERGENCY LIGHT COVER PER AMM 33-51-00.SDR YENA201701220045Battery Pack · failedEMERGENCY LIGHTS IN AUTO DID NOT ILLUMINATE WHEN POWER DROPPED OFF. R & R THE BATTERY PACK AT 10WL IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA20170124022Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN MID GALLEY AFTER ROW 17 RIGHT SIDE HAS A DETACHED LENS COVER. RE-ATTACHED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170124020Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR HAS A DETACHED LENS COVER. RE-ATTACHED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170124017Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE SEAT 24ABC IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170124016Pin · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR IS DETACHED DUE TO BROKEN PINS. REMOVED AND REPLACED PINS. OPERATIONAL CHECK GOOD.SDR AALA20170124013Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 31C IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170123001Battery · failedAIRCRAFT WAS NOT GROUNDED. R2 DOOR EXIT LIGHT EMERGENCY POWER SUPPLY UNIT AT 12WL FAILED CHECK. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017012411437Light · inoperativeRT EMERGENCY EXIT LIGHT INOP AT ROW 16. R&R LIGHT PER AMM.SDR SWAA2017012411434Lens · missingL1 DOOR LOWER EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017012411427Light · inoperativeRT EMERGENCY EXIT LIGHT INOP AT ROW 16. REPAIRED LIGHT PER MM.SDR ASAA2017012219514Lens · missingL2 EXIT SIGN MISSING. ACFT GROUNDED. . REPLACED LENS AND TESTED THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-801. OPS NORMAL.
Back to JASC 3350