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 AALA20180212005Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE, BS 1200, OVERHEAD AREA. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-53-00, AND PERFORMED A SATISFACTORY OPS CHECK.SDR HNAA2018021400029Warning Message · false activationEMERGENCY LIGHTS NOT ARMED CAUTION MESSAGE, DISPLAYED RANDOMLY 4 - 5 TIMES ON EICAS, SWITCH WAS VERIFIED TO BE IN THE ARMED POSITION. OPS CHECKED THE EMERGENCY LIGHTING SYSTEM, FOUND GOOD AT THIS TIME IAW 33-50-00. NO ERRONEOUS MESSAGES NOTED. OK FOR SERVICESDR DALA2018021300866Battery Pack · inoperativeFOUND ROWS 1, 2, AND 3 EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK, M730. EMERGENCY LIGHTS OPS NORMAL.SDR ASOA201802124009Light · unknownDURING PREFLIGHT INSPECTION, THE CREW REPORTED THA THE AISLE EMERGENCY LIGHT STRIPS AT SEATS 3C & 4C WERE FOUND TO BE NOT GLOWING. MAINTENANCE INSPECTED THE AIRCRAFT , OPERATIONALLY TESTED THE LIGHTS WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RESDR ASOA201802124008Light · unknownDURING A PREFLIGHT INSPECTION, THE CREW REPORTED THA THE AISLE EMERGENCY LIGHT STRIPS AT SEATS 3C & 4C WERE FOUND TO BE NOT GLOWING. MAINTENANCE INSPECTED THE AIRCRAFT , OPERATIONALLY TESTED THE LIGHTS WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR SDR SIMA20180212001Light · inoperativeCOCKPIT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE COCKPIT EMEGENCY LIGHT IAW AMM 33-50-05-000-801, AND 33-50-05-400-801. OPS CHECKED GOOD.SDR DALA2018021200855Battery Pack · failedL1 & R1 DOORS AND FLIGHT DECK EMERGENCY LIGHTS INOPERATIVE. AFTER TROUBLESHOOTING, FOUND THE BATTERY PACK FAILED. REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-50.SDR CALA2018021200611Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1695 IS INOPERATIVE. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR CALA2018021200610Lamp · inoperativeR1 EMERGENCY DOOR SLIDE EXTERNAL LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-40-00. OPS CHECKED GOOD.SDR CALA2018021200609Fuse · shortedEMERGENCY LIGHTS ON SEATS 18 AND 19C ARE OUT. FOUND AISLE LIGHT SHORTED FUSE F1 ON POWER SUPPLY M11487. REPLACED THE FUSE, CHECKED NORMAL IAW WDM33-5 1-21.SDR CALA2018021200607Battery · dischargedBOTH OVERWING EXIT HATCH ESPU BATTERIES ARE DISCHARGED. REMOVED AND REPLACED THE BATTERIES IAW AMM 3 3-51-38-000-0002-A, 33-51-38-400-002-A, AND PERFORMED AN OPS TESTED IAW AMM 33-51-38-710-052-A. NO DEFECT FOUND.SDR DALA2018021200842Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE ON THE RT SIDE OF THE ACFT. REPLACED THE EPSU 16WL.SDR REXA2018021100130Battery Pack · inoperativeDURING LINE CHECK, THE EXTERIOR AND INTERIOR EMERGENCY LIGHTS DID NOT ILLUMINATE. R & R THE BATTERY PACK AT PS3LF IAW 33-900-701, OPS CHECKED GOOD.SDR AALA201802159020Lens · detachedEXIT SIGN LENS ROW 21 LEFT SIDE FELL OFF. MAINTENANCE INSTALLED AND SECURED EXIT SIGN LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-09-422-042.SDR SIMA20180211003Housing · damagedFOUND THE LT WING EMERGENCY LIGHT HOUSING TO BE DAMAGED, R & R THE LT EMERGENCY LIGHT HOUSING IAW AMM 33-50-10, OPS CHECKED GOOD IAW WC 33-700-17. NO DEFECTS NOTED.SDR AALA20180212003Battery Pack · inoperativeCABIN SEAT EMERGENCY LIGHTS INOPERATIVE FROM ROW 23H TO 28H. REMOVED AND REPLACED THE BATTERY M734 IAW AMM 33-51-07. ALL LIGHTS OPS CHECKED NORMAL.SDR AALA201802149006Lens · brokenLENS BROKEN ON THE EXIT SIGN IN THE GALLEY. REPLACED THE LENS IAW AMM 33-51-01.SDR AALA201802129065Light · malfunctionedEMERGENCY LIGHTS REQUIRED A RESET AND CAME ON AGAIN ON LANDING. ACCOMPLISHED TSM 33-51-00-810-881-A, AND AMM 33-51-00-710-004-A. OPS TESTED NORMAL. NO 60 DAY HISTORY. SYSTEM OPERATIONS NORMAL.SDR SWAA2018021319688Lens · detachedOVERWING EXIT SIGN PLASTIC LENS DETACHED. REINSTALLED THE LENS IAW AMM.SDR DALA2018021200871Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 25, REPLACED THE LIGHT.SDR AALA201802139014Lens · missingFLOOR EMERGENCY LIGHT LENS AT THE R4 DOOR WAS MISSING. MAINTENANCE INSTALLED THE LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-18.SDR SIMA20180211002Power Supply · inoperativeDURING A PS-1 CHECK, FOUND THE LT FRONT AREA OF WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW 33-700-19.SDR DALA2018021200858Relay · failedDURING WALK AROUND, ODSERVED OVERWING EMERGENCY LIGHT ON, ALSO ON EOAP EMERGENCY POWER AUTO FAULT AND MWCC STATUS MESSAGE. TROUBLESHOT FOUND EMERGENCY LIGHT WILL NOT TURN ON FROM COCKPIT SWITCH WILL WORK ON THE F/A FWD PANEL BUT WILL NOT TURN OFF AT F/A PANESDR MASA2018021112970Light · inoperativeROW 9 OVHD EMER FLOODLIGHT INOP. RELAMPED LIGHT.SDR CALA2018021100600Battery Pack · faultyEMERG LIGHT OUT AT L2 DOOR. FOUND BATTERY PACK BAD. R&R BATTERY PACK FOR L2 DOOR. OPS CKS GOOD.SDR CALA2018021100599Light · inoperativeROW 28 RT SIDE EMERGENCY LIGHT COMMON TO BAG BIN IS OUT. RELAMPED EMERGENCY LIGHT AT ROW 28 RT, OPS CHK'S GOOD.SDR CALA2018021100598Light · inoperativeEXTERIOR EMERGENCY LIGHT AT DOOR 3L INOP. RELAMPED EMERGENCY LIGHT AT DOOR 3L. OPS CHECK GOOD.SDR CALA2018021100595Light · missing34F EMERGENCY PATH LIGHT MISSING. REPLACED 34F EMERGENCY PATH LIGHT OPS CHECKS GOOD.SDR CALA2018021100597Lens · missingFLT ATTN REPORTED FIRST CLASS COAT CLOSET HAS A LENS MISSING FOR EMERGENCY EXIT LIGHT. REMOVED AND REPLACED LIGHT ASSY AT F/C CLOSET, OK TO CONTINUE.SDR CALA2018021100596Light · damagedEMER ESCAPE PATH MARKING LIGHT AT 33F AND 32F IS PUSHED IN. REPLACED EMER ESCAPE PATH MARKING LIGHT AT 33F AND 32F OPS CHECKS GOOD.SDR CALA2018021000588Light · brokenSPEC NO.B777-33-3-6019 M/D ZONE A & B PARTITION AREA 4EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN ZONE A & B PARTITION AREA 4EA LWR EMERGENCY LT ASSY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-0 5-960-802 REV 81.SDR SWAA2018021919762Lens · looseRIGHT OVERWING EMERGENCY LIGHT LENS LOOSE. R & R THE LENS IAW AMM.SDR SWAA2018021919721Sign · looseMID CABIN OVERHEAD OVERWING EXIT SIGN BROKEN LOOSE. REINSTALLED THE SIGN IAW MM.SDR SWAA2018021919720Lamp · inoperativeR2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201802159019Power Supply · inoperativeEMERGENCY LIGHT INOPERATIVE BETWEEN THE R3 AND R4 DOORS. REPLACED THE POWER SUPPLY AND OPS CHECKED OK IAW AMM 33-51-06-960-803.SDR AALA201802159018Lens · brokenAFT R3 DOOR EXIT SIGN LENS BROKEN. REPLACED THE LENS IAW MM 33-51-10.SDR AALA201802159017Lens · missingL4 DOOR EMERGENCY EXIT LIGHT LENS IS MISSING. REPLACED THE LENS IAW AMM 33-50-00.SDR AALA201802159016Lens · detachedR1 DOOR BOTTOM EXIT SIGN LENS WAS FALLING OFF. MAINTENANCE INSTALLED EXIT SIGN LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802139013Lens · brokenL4 DOOR EMERGENCY LIGHT LENS BROKEN. MAINTENANCE REPLACED THE LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802129053Sign · damagedFORWARD L1 DOOR EXIT SIGN DAMAGED. REPLACED THE SIGN.SDR DALA2018021200849Light · inoperativeEMERGENCY LIGHT, CEILING AT ROW 16 ABC INOPERATIVE. R & R THE LIGHT ASSY IAW AMM 33-51.SDR DALA2018021000839Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, REPLACED THE BATTERY PACK.SDR CALA2018021100590Sign · brokenM/D R3 DOOR FWD 1EA EXIT INDENT'S BASE FOUND BROKEN. REPLACED THE CABIN R3 DOOR FWD 1EA EXIT SIGN AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960-802 REV 81.SDR U2RA201802110002Battery · dischargedDOORS 3 LEFT AND 3 RIGHT EXTERNAL EMERGENCY LIGHTS ARE INOPERATIVE. CHARGED EMERGENCY LIGHT BATTERIES PER AIRCRAFT MAINTENANCE MANUAL 33-51-07. LIGHT OPERATES NORMALLY AFTER CHARGING.SDR U2RA201802110001Battery · dischargedINTERNAL EMERGENCY LIGHT AT NUMBER 3 LEFT DOOR IS INOPERATIVE. - CHARGED EMERGENCY LIGHT BATTERIES PER AIRCRAFT MAINTENANCE MANUAL 33-51-07. LIGHT OPERATES NORMALLY AFTER CHARGING.SDR MASA2018021012967Lamp · inoperativeCEILING EMERGENCY FLOODLIGHT AT ROW 9 INOPERATIVE. REPLACED THE LAMPS.SDR CALA2018021000587Light · brokenMAIN DECK A4 GALLEY CENTER LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY, OP TESTED NORMAL IAW AMM 33-51-05-960-802, REV 81.SDR CALA2018021000586Light · brokenMAIN DECK DOOR CENTER PARTITION HAD ONE LOWER EMERGENCY LIGHT WAS FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05-9 60-802, REV 81.SDR CALA2018021000585Light · brokenMAIN DECK M1 GALLEY, ONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05-960-802, REV 81.SDR CALA2018021000583Battery · inoperativeTHE EMERGENCY LIGHT EXIT SIGN AT THE RT ENTRY DOOR FOUND INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-51-07, OPS CHECKED OK.
Back to JASC 3350