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 SWAA2019111938927Battery Pack · inoperativeL2 DOOR UPPER EMERGENCY EXIT LIGHT INOP. / R&R BATTERY PACK M1672 PER AMM.SDR SWAA2019111938920Bulb · inoperativeR/H FUSELAGE EMERGENCY LIGHT INOP FORWARD OF AFT CARGO DOOR. / R&R BULB PER AMM.SDR DALA2019111806754Cover · damagedEMERGENCY LIGHT COVER AT SEAT 37H DAMAGED. REPLACED LIGHT ASSEMBLY. LP 1362050SDR SIMA201911186001Light · inoperativeL/H OVERWING EMERGENCY LIGHT INOP-C/A-RAR LEFT OVERWING EMERGENCY LIGHT ASSY OPC GOOD AMM 33-50-01SDR DALA2019111806743Power Supply · inoperativeDURING SERVICE CHECK MAINTENANCE FOUND THAT THE LOWER EMERGENCY EXIT IDENTIFIERS WERE INOPERATIVE AT ROW 20. MAINTENANCE REPLACED POWER SUPPLY B5-119. OPERATIONAL CHECK IS GOOD. AIRCRAFT IS OK FOR SERVICE. (LP #6754276)SDR DALA2019111606732Battery Pack · inoperativeOVER WING EMERGENCY EXIT LIGHT INOP DURING SVC. REPLACED EMERGENCY BATTERY PACK PER MD-88 AMM 33-53-00. SYSTEMS CHECK NORMAL. (LP6658656)SDR CALA2019111601999Light · shortedFIRST CLASS SEATS EMERGENCY EXIT LIGHTS INOP FOUND ROW 4AB SHORTING OUT BLOWING FUSE IN CHARGER REPLACED BOTH LIGHTS AT SEAT 4ABSDR SWAA2019120939451Battery Pack · inoperativeBOTH SIDES EMERGENCY EXIT DOORS LIGHT INOP AND LEFT SIDE AFT GALLEY AND LAV. / R&R BATTERY PACK IAW AMM.SDR SWAA2019120239292Light · crackedCENTER PASSENGER CABIN OVERHEAD EMERGENCY EXIT LIGHT ATTACH BASE CRACKED IN SEVERAL PLACES. / R&R LIGHT IAW AMM.SDR DALA2019112276830Power Supply · no testLLCR EMERGENCY POWER SUPPLY INOPERATIVE DURING TEST. REPLACED LLCR EMERGENCY POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR SWAA2019111938970Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK AT LOCATION M1675 FAILED TEST. / R&R BATTERY PACK PER AMM.SDR SWAA2019111938969Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK AT LOCATION M1674 FAILED TEST. / R&R BATTERY PACK PER AMM.SDR SWAA2019111938953Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK AT LOCATION M1672 FAILED TEST. / R&R BATTERY PACK PER AMM.SDR SWAA2019111938946Lens · missingOVERHEAD CENTER AISLE EMERGENCY EXIT LENS COVER MISSING. / R&R LENS COVER PER SIP.SDR SWAA2019111938932Light · inoperativeFORWARD ENTRY GROUND PROXIMITY EMERGENCY LIGHTS INOPERATIVE. / R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019111938931Lamp · inoperativeR/H OVERWING EXIT GROUND LIGHT INOPERATIVE. / RELAMPED LIGHT PER AMM.SDR SWAA2019111938921Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019111938918Lens · brokenEXIT SIGN AT FORWARD ENTRANCE BROKEN. / SECURED LENS PER SIP.SDR SWAA2019111938897Light · missingR/H OVERWING EMERGENCY EXIT LOWER LIGHT LENS NOT BILINGUAL & MISSING DIRECTIONAL ARROW. / R&R LIGHT PER AMM.SDR ASAA2019111851361Lens · detachedTHE EXIT SIGN AT SEAT 17F FELL OFF THE WALL. GROUNDED - YES. REPLACED EMERGENCY EXIT SIGN AT ROW 17F - OPS OK.SDR AALA201911189020Power Supply · no testAIRCRAFT NOT GROUNDED: MAINTENANCE FOUND 13WL FAULTING DURING PS CHECK. REMOVED & REPLACED EPSU ON POSITION 13WL. PERFORMED OPS CHECK IAW AMM 33-51-38 & TSM 33-51-00-810-836-A.SDR DALA2019111876750Sign · inoperativeDURING SERVICE CHECK, EXIT SIGN IN BULK CARGO CREW REST IS INOPERATIVE. FABRICATED BRACKET ASSEMBLY AND INSTALLED PER ER/A 583027-14. LP 1361685SDR SIMA201911185003Bulb · inoperativeSERVICE DOOR HINGE COVER EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR HINGE COVER EMERGENCY LIGHT BULB IAW EMB 140 AMM 33-50-10 2. K (1) (2) (3) AND 3. J (1) (2) (3). OPS CHECK GOOD.SDR SIMA201911185002Lamp · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-RAR RH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A OPC GOOD.SDR SIMA201911185004Light · inoperativeDURING PS-2 FOUND EXTERIOR RH FWD EMERGENCY LIGHT INOP-C/A-RAR EXTERIOR RH FWD EMERGENCY LIGHT IAW 145 AMM 33-50-10 OPS-CHECK GOOD NO FURTHER DEFECTS NOTEDSDR DALA2019111806742Sign · missingTHE EMERGENCY EXIT SIGN ABOVE DOOR 1L IS MISSING AND INOPERATIVE. MAINTENANCE INSTALLED A NEW LENS COVER. EMERGENCY LIGHT EXIT SIGN NOW CHECKS GOOD AT DOOR 1L IAW B717 AMM 33-51. (LP #1361214)SDR CALA2019111601998Charger · inoperativeB777-33-3-7019, LH NO.3 DR EXIT SIGN FOUND INOP REFER TO NR LP 9130026. LH NO.3 DR EMER LT BATTERY CHARGER M33405 REPLACED & TEST OKAY I.A.W AMM 33-51-06.SDR CALA2019111601997Charger · failedB777-33-3-7019, EMER PWR SUPPLY M33094 CHARGER CAPACITY CHECK FAIL REFER TO NR LP 9130029. EMER PWR SUPPLY M33094 CHARGER REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL I.A.W AMM 33-51-06.SDR CALA2019111601996Power Supply · failedB777-33-3-7019, EMER PWR SUPPLY M33094 BATTERY CAPACITY CHECK FAIL, REFER TO NR LP 9130028 EMER PWR SUPPLY M33094 BATTERY REPLACED AND INSTALLATION TEST CA RRID OUT RESULT NORMAL IAW AMM33-51-06SDR CALA2019111601995Battery · failedB777-33-3-7019, R/H DR4 CEILING EMER LT INOP, REFER TO NR LP 9130025 RH NO.4 DR EMER LT BATTERY M33408 REPLACED AND TEST OKAY IAW AMM33-51-06 ADD EMP:V896910SDR CALA2019111601994Fuse · failedEMERGENCY LIGHT OUTSIDE OF DOOR RIGHT INOP. SHOULD SAY DOOR 1R. RELAMP NO HELP. FOUND FUSE SET #2 (3RD FROM LEFT) OPEN ON PWR CONNECTOR D14812 REF WDM 33-51-12 HAS SHORT TO GROUND. INSPECTED LIGHT ASSY AND TERMINALS NO FAULT FOUND. PWR SUPPLY M2816 IS MISSING SDR CALA2019111601993Battery · inoperativeB777-33-3-7019, DR3 L/H EXIT SIGN FOUND INOP, REFER TO NR LP 9130027 LH NO.3 DR EMER LT BATTERY M33400 REPLACED AND TEST OKAY IAW AMM 33-51-06 ADD EMP:V896910SDR MASA2019111512140Battery Pack · inoperativePAX DOOR EXT EMERG LIGHT INOP. REMOVED AND REPLACED BATTERY PACK #1.SDR DALA2019111506705Battery Pack · inoperativeDURING SVC FOUND FWD CABIN EMERGENCY LIGHT INOP. T/S PER MD88 AMM:33-50 AND ROBBED EMERGENCY BATTERY FROM A/C 963 . OPS CHECK OK A/C OK FOR SVC. (LP6658249)SDR DALA2019111506704Fuse · failedEMER LIGHTS ROW 31-36 INOP. RPLCD FUSE ON BATTERY PACK. ALL EMER LIGHTS NOW CK GOOD. REF MD88 AMM 33-50. (LP6658807)SDR FDEA2019111542953Battery Pack · no testL1 DOOR SLIDE LIGHT WILL NOT TEST. REPLACED SLIDE INDICATOR BATTERIES, OPS CHECKS GOOD. REF MD10MM 25-61-02-2.SDR SWAA2019111938967Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT POSITION M1675. / R&R BATTERY PER AMM AND DWG.SDR SWAA2019111938966Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT POSITION M1674. / R&R BATTERY PER AMM AND DWG.SDR SWAA2019111938919Lens · brokenR/H OVERWING EMERGENCY EXIT LIGHT BROKEN OFF WOULD NOT STAY IN PLACE. / INSTALLED LENS IAW AMM.SDR SWAA2019111938909Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT POSITION M1669. / R&R BATTERY PER AMM AND DWG.SDR SWAA2019111838860Battery Pack · inoperativeR2 DOOR EMERGENCY EXIT LIGHT ABOVE DOOR DID NOT WORK. / R&R M1673 BATTERY PACK PER AMM.SDR SWAA2019111838859Battery Pack · inoperativeAFT LAV EMERGENCY EXIT LOCATOR LIGHT OUT. / R&R M1673 BATTERY PACK PER AMM.SDR SWAA2019111838858Battery Pack · inoperativeL2 DOOR EMERGENCY SIDE LIGHT OUT. / R&R BATTERY PACK PER AMM.SDR N6WA20191118402Light · missingRED CAP ON MID CABIN EMERGECNY CEILING LIGHT MISSING ON AFT SIDE. FOUND RED CAP FROM AA CEILING EMERGENCY EXIT ROW SIGN INSIDE LENS RE-INSTALLED RED CAP TO CEILING MOUNTED EMERGENCY EXIT IAW CRJ AMM 33-51-07.SDR DALA2019111506753Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE, RESET CIDS. LP 1359164SDR N6WA20191118401Light · detachedEMERGENCY LIGHT BY SERVICE DOOR DETACHING. FOUND AFT LOWER GALLEY EMERGENCY LT ASSEN MISSING SCREWS INSTALLED NEW MDW IAW CRJ AMM 20-21-00.SDR AALA201911159009Cover · detachedAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT COVER FELL OFF AT DOOR 3L. MAINTENANCE FOUND BULB WIRES DETACHED. MAINTENANCE REPAIRED SOLDERING THE WIRES TO THE CIRCUIT BOARD PER ESWP 20-51-30, REATTACHED LIGHT COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK PSDR IPXA2019111548992Battery Pack · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHTS INOPR&R EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-51-07. OP/C GOOD.SDR DALA2019111546716Lens · detached(AIRCRAFT 5653, L/P 6312674) 2R EXIT COVER FALLS OFF. CORRECTIVE ACTION: SECURED SAME.SDR SIMA201911154003Battery Pack · inoperativeEMERGENCY LIGHT FROM EXIT ROW AFT TURNING ON AND OFF INTERMITENTLY DURING FLIGHT-C/A-RAR EMERGENCY LIGHT BATTERY ASSY NO:3 IAW EMB 145 AMM 33-50-04
Back to JASC 3350