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 CALA2017032700755Light · crackedAFTER SEAT 2C PARTITION LT & RT EMERGENCY LIGHT FOUND CRACK. REPLACED THE 2C SEAT PARTITION LT & RT EMER LIGHT ASSY AND C/O EMER LIGHT SYSTEM OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00- 710-801 REV 79.SDR CALA2017032700753Light · crackedAFTER 10AC PARTITION LT & RT EMERGENCY LIGHT FOUND CRACK. REPLACED THE 10AC PARTITION LT & RT EMER LIGHT AND C/O EMER LIGHT SYSTEM OPERATION TEST FOUND NORMAL, REF AMM 33-51-00-710-801 REV 79.SDR CALA2017032700752Fuse · blownC/O EMER LIGHT OPERATION TEST FOUND RT 39 & 41 CEILING PANEL EMER LIGHT INOP. REPLACED THE EMER LIGHT BATTERY PACK FUSE AND C/O EMER LIGHT OPERATION TEST FOUND NORMAL REF AMM 33-51-00-710-801 REV 79.SDR CALA2017032700751Power Supply · faultyEMERGENCY LIGHTS FLICKERING IN BACK OF AIRCRAFT RMVD AND RPLD POWER SUPPLY AND BATTERY PACK, OPS CHKD OK.SDR CALA2017032700750Power Supply · inoperativeEXT FUSELAGE AFT OF DOOR 2L, EMERG EXIT LIGHT INOP. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK (M733) OPS TEST FOUND NORMAL AS PER REF AMM 33-51-07.SDR CALA2017032700749Power Supply · faultyEMERGENCY EXIT LIGHTS AT L-2 DOOR & CEILING AREA ARE INOP. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK (M733) AND PERFORMED OPS TEST FOUND NORMAL AS PER REF AMM 33-51-07.SDR CALA2017032700748Light · faultyDOOR 1L EMERGENCY EXIT LIGHTS CAME ON 45 MINS INTO FLT STDY AT FIRST THEN FLICKERED. PRES NORMAL REMOVED UPPER L1 DOOR EMERGENCY EXIT LIGHT, INSPECTED CONNECTION WIRES WITH NO ISSUES NOTED. REPLACED UPPER L1 EXIT LIGHT ASSY REF AMM 33-51-01. OPS CHECK NORMAL.SDR CALA2017032700747Power Supply · inoperativeROW 4AB EMERGENCY LITE IN BULLNOSE INOP. RPLD POWER SUPPLY M733. OPS CK OK PERFORMED RII INSP OF POWER SUPPLY AND OPS CK . NO DEFECTS FOUND.SDR CALA2017032700744Light · inoperativeEMERGENCY FLOOR PROXIMITY LIGHT AT SEAT 15ABC, 20ABC, 21ABC AND LT OVERWING EXIT INOP.SDR CALA2017032700743Light · brokenM/D L3 DOOR FWD 1EA EXIT IDENTIFIER FOUND BROKEN. REPLACED THE CABIN M/D L3 DOOR FWD 1EA EXIT IDENTIFIER INDICATOR AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960-802 REV 79.SDR CALA2017032700742Battery · dischargedM/D L1 DOOR HEADER 1EA EMER LT PWR PACK (M33093) FOUND LOW CAPACITY. REPLACED THE M/D L1 DOOR HEADER EMERGENCY POWER PACK BATTERY AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 79.SDR CALA2017032700741Battery · dischargedM/D R1 DOOR HEADER 1EA EMER LT POWER PACK (M33094) FOUND LOW CAPACITY. REPLACED THE M/D R1 DOOR HEADER EMERGENCY LT POWER PACK BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 3351-06-960-802 REV 79.SDR MASA2017032612695Lamp · inoperativeAFT GALLEY EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2017032712696Bulb · inoperativeFLOOR LEVEL EMERGENCY EXIT SIGN HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR AALA201703299030Lens · missingEMERGENCY LIGHT ASSY LENS CAP MISSING AT RIGHT DOOR EXIT AFT GALLEY AREAS - LIGHT TEST OK. REMOVED AND REPLACED LUMINAR EXIT IDENT ASSY AT DOOR EXIT RIGHT AFT GALLEY AREAS IAW AMM 33-51-01. OPS CHECK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299029Lens · missingROW 15 EMERGENCY EXIT LIGHT ON WALL MISSING ITS COVER. REPLACED EMERGENCY LIGHT LENS AT ROW 15. OPS CHECK GOOD. REF AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299028Sign · damagedAFT RIGHT SERVICE DOOR EMERGENCY EXIT SIGN WON’T STAY ATTACHED. REMOVED & REPLACED DAMAGED EMER. EXIT LIGHT ASSY. AT AFT RIGHT GALLEY AREA OPS CHKS NML. PER AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR SIMA20170326004Light · inoperativeEMERGENCY EXIT FLOOR STRIP BTW 8A AND 9A INOP. REMOVED AND REPLACED EMERGENCY EXIT FLOOR STRIP BTW 8A AND 9A IAW AMM 33-50-12.SDR AALA20170327002Lens · missingFOUND EMERGENCY LIGHT ASSY LENS CAP MISSING DURING MTC. A CHECK. LIGHT TESTED OK. REMOVED AND REPLACED LUMINAR EXIT IDENT ASSY AT DOOR EXIT RT AFT GALLEY IAW AMM 33-51-01. OPS CKS OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170326003Power Supply · dischargedEMERGENCY EXIT LIGHT FAILED TEST FIRST CLASS. EMERGENCY BATTERY POWER SUPPLY M33098 FOR FIRST CLASS RIGHT SIDE REPLACED. THE AIRCRAFT WAS GROUNDED.SDR SWAA2017032912839Sign · detachedL1 DOOR LOWER EMERGENCY EXIT SIGN FELL OFF. SECURED THE SIGN IAW AMM.SDR ASAA2017032620280Light · inoperativeEMERGENCY LIGHT EXIT SIGN ABOVE L-1 DOOR HAS SEVERAL LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR KCSA2017032602Lamp · inoperativeLEFT UPPER DECK EMERGENCY DOOR BATTERY PACK FAILED A CHECK. REPLACED THE LAMP IN THE BATTERY LIGHT SWITCH IAW SWPM 20-84-13. OPS CHECKED GOOD IAW MM 52-23-00. NO DEFECTS NOTED.SDR AALA201703279031Lens · missingSEAT 18ABC EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201703279029Lens · missingR4 DOOR EXIT SIGN MISSING THE LENS. REPLACED THE LENS.SDR AALA201703279052Battery · failedAIRCRAFT WAS GROUNDED. EPSU BATTERY FAILED AT 16WL DURING JOB CARD 33C22033002. REPLACED BATTERY.SDR AALA201703279051Battery · failedAIRCRAFT WAS GROUNDED. EPSU BATTERY FAILED AT 11WL DURING JOB CARD 33C22033002. REPLACED BATTERY.SDR YENA201703260216Battery Pack · no testDURING ROUTINE MAINTENANANCE, BATTERY FAILED EMERGENCY LIGHT TEST. REPLACED THE BATTERY PACK, CHECKED OK.SDR SIMA20170326001Battery Pack · inoperativeNR 2 AND 3 FLOOR EMERGENCY LIGHTS DID NOT ILLUMINATE. REMOVED AND REPLACED BATTERY AND CHARGER ASSEMBLY IAW 33-700-19. OPS CHECKED GOOD IAW 33-700-17. NO DEFECTS FOUND.SDR DALA2017032702438Cover · looseEMERGENCY EXIT SIGN COVER LOOSE LOCATIONS:01R. EMERGENCY EXIT COVER FIXED.SDR CALA2017032600735Lens · missingEMER EXIT SIGN MISSING ROW 20. INSTALLED PROPERLY EMER EXIT LENS. A/C OK TO CONTINUE.SDR CALA2017032600734Light · missingSEAT 31C EMER LITE MISSING. INSTALLED NEW EMER LITE AT SEAT 31C. OPS CHECK GOOD.SDR CALA2017032600737Epsu · defectiveESCAPE PATH LIGHTS ROW 10-11 INOP. T/S FOUND EMERGENCY POWER SUPPLY UNIT 10WL DEFECTIVE. REMOVED AN D REPLACED EPSU AMM 33-51-38. OPS CKS GOOD.SDR CALA2017032600736Light · looseMID LAV EEL LITE INOP. SECURED LOOSE LAMP, CKS OK ACCOMPLISHED IDT MID LAV EEL LITE. OP CK GOOD.SDR CALA2017032600733Light · damagedEMER LIGHT STRIP IN FRONT OF ROW 21 DEF INOP. NOT SECURED TO THE FLOOR AND POWER RIBBON CUT TO THE LT STRIP R&R THE LIGHT STRIP REF TO AMM 33-51-10, TESTED GOOD. VERIFIED REPLACEMENT OF LIGHT STRIP, OPS CKS GOOD.SDR AALA201703299022Sign · damagedWHILE ACCOMPLISHING MCM CARD 2904, FOUND L2 DOOR EMERGENCY EXIT SIGN DAMAGED, LIGHT WORKS NORMAL. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT SIGN ASSY PER AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299021Lens · missingEXIT LIGHT COVER AT R1 DOOR IS MISSING. REPLACED LENS COVER FWD GALLEY EMERGENCY EXIT SIGN PER MM 33-50-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299020Light · defectiveEMER LIGHT COVER IN FRONT GALLEY WILL NOT STAY ON. REPLACED EMER LIGHT ASSY AS PER MM 33-51-00 OP CK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299019Lens · brokenEMERGENCY FLOOD LIGHT ASSY LENS ARE CRACKED & BROKE ON AISLE RT SIDE OF F/C GALLEY. REPLACED EMERGENCY FLOOD LIGHT ASSY FWD RT AISLE AT F/C GALLEY IAW 33-51-01. OPS CK GOOD IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017032912841Lens · looseFORWARD DOOR EMERGENCY EXIT LENS LOOSE. SECURED THE LENS IAW SIP.SDR AALA20170325002Battery Pack · dischargedDURING OPS CHECK WAS FOUND SOME EMERGENCY LIGHTS INOP NEAR DOOR 3L. REMOVED AND REPLACED A BATTERY PACK POS. M33405 ABOVE THE DOOR 3L IAW AMM 33-51-06. GOOD FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR R61A201703250250Circuit Card · malfunctionedDURING FLIGHT, THE EMERGENCY LIGHTS ACTIVATED ON THEIR OWN WITH EMERGENCY LIGHTS ON DISPLAYED ON THE EICAS. SWITCH ALWAYS REMAINED ARMED. R & R THE SPDA 1 DISC I/O MOD SLOT 11 IAW AMM 24-61-05. OPS CHECKED GOODSDR YENA201703250217Power Supply · no testDURING ROUTINE MAINTENANCE, AFT EMERGENCY LIGHT ESPU FAILED A CHECK. REPLACED THE POWER SUPPLY. CHECKED OK.SDR AALA201703279046Lens · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKS ON RT OVERWING EMERGENCY EXIT BOTTOM SIGN CASE. REPLACED RT OVERWING EMERGENCY EXIT SIGN IDENTIFIER.SDR AALA201703279045Lens · crackedAIRCRAFT IN BASE MAINTENANCE. RT OVERWING TOP EMERGENCY EXIT SIGN LENS CRACKED. REPLACED RT OVERWING TOP EMERGENCY EXIT SIGN LENS.SDR AALA201703279044Sign · brokenAIRCRAFT IN BASE MAINTENANCE. AFT DOOR LT FUSELAGE, BOTTOM EMERGENCY EXIT SIGN CASE BROKEN. REPLACED AFT DOOR LT FUSELAGE BOTTOM EMERGENCY EXIT SIGN IDENTIFIER.SDR AALA201703279043Sign · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKS IN LT FORWARD ENTRY DOOR BOTTOM EMERGENCY EXIT LIGHT SIGN CASE. REPLACED LT FORWARD ENTRY DOOR BOTTOM EMERGENCY EXIT LIGHT SIGN.SDR AALA201703279021Lens · missingFLIGHT ATTEDANTS ADVISE THAT L4 DOOR EXIT LIGHT SIGN LENS IS MISSING. REPLACED THE LENS.SDR AALA201703279009Lens · unsecureFIRST CLASS CABIN WALL EXIT LIGHT LENS UNSECURE. SECURED THE LIGHT, OPS NORMAL.SDR AALA201703279005Lens · missingAFT RIGHT DOOR EXIT SIGN LENS MISSING. REPLACED THE SIGN.
Back to JASC 3350