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 SIMA201911121001Lamp · inoperativeROW 17 CEILING EMERGENCY LIGHT INOP-C/A-RAR ROW 17 CEILING EMERGENCY LAMP IAW AMM TASK 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD. END.SDR SIMA201911121002Bulb · inoperativeBOTH LH AND RH EXTERNAL AFT EMERGENCY LIGHTS INOP-C/A-RAR BOTH LH AND RH EXTERNAL AFT EMERGENCY LIGHTS BULBS IAW EMB AMM 33--50-10-000-801-A AND 33-50-10-400-801-A NO FIX FURTHER T/S PER WM 33-50-50 RAR #4 EMERGENCY BATTERY AND CHARGER IAW W/C 33-700-19 SDR 2020F00064Battery Pack · inoperativeEMERGENCY LIGHT BETWEEN DOOR 2L AND 2R INOPERATIVE DURING OPERATIONAL TEST.SDR SWAA2019111438837Light · damagedG1 GALLEY EMERGENCY EXIT LIGHT DAMAGED. / R&R LIGHT PER AMM.SDR AALA2019111329010Control Unit · no testAIRCRAFT WAS GROUNDED: FIRST CLASS SEATS 1D, 2D, 1H, 2H EMERGENCY LIGHTS WOULD NOT TEST, ONLY CAME ON WHEN POWER WAS REMOVED FROM AIRCRAFT. MAINTENANCE REPLACED #17 WCU PER AMM DMC-B787-A-33-51-07-01A-520A-A.SDR DALA2019111326621Lens · loose(AIRCRAFT 6702, L/P 1354121) EMERGENCY EXIT SIGN COVER LOOSE / INTERIOR. CORRECTIVE ACTION: INSTALLED LENS COVER.SDR DALA2019111326620Light · not reported(AIRCRAFT 6813, L/P 1353213) ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHTS - 1R SLIDE LIGHT. CORRECTIVE ACTION: R/R 1R SLIDEARM LIGHT PER B757 AMM 33-51.SDR DALA2019111216586Cover · missingAFT LEFT DOOR EMERGENCY LIGHT COVER MISSING, INSTALLED AFT LEFT DOOR EMERGENCY LIGHT COVERSDR DALA201911126585Battery Pack · faultedFOUND LLCR THE EMERGENCY LIGHT BATTERY FAULT. REPLACED BATTERY. SYSTEM OPERATION NORMAL.SDR SWAA2019111238789Light · brokenFORWARD LAV EMERGENCY EXIT LIGHT BROKEN. / R&R LIGHT IAW AMM.SDR SWAA2019111238764Cover · looseOVERWING EMERGENCY EXIT SIGN CENTER OVERHEAD, SIGN COVER LOOSE. / SECURED COVER PER AMM.SDR AALA2019111219026Control Unit · defectiveAIRCRAFT WAS NOT GROUNDED: 3L DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED CONTOL UNIT.SDR SIMA201911110007Light · inoperativeCOCKPIT EMERGENCY LIGHT INOP-C/A-RAR COCKPIT EMERGENCY LIGHT IAW AMM TASK 33-50-05-000-801-A AND 33-50-05-400-801-A. OPC GOOD. END.SDR SWAA2019111138741Power Supply · inoperativeR/H EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN SEAT ROW 16 TO ROW 17. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019111138727Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SIMA201911110002Lamp · inoperativeSERVICE-DOOR EMERGENCY LIGHT INOP-C/A-SERVICE-DOOR EMERGENCY LIGHT LAMP RAR IAW EMB140 AMM 33-50-09. OPC GOOD.SDR SIMA201911110005Light · dimHEAVY CHECK POST MAINT WALKAROUND PRIOR TO RELEASE IAW GPM 4-16C(H) BY ENVOY CARRIER TECH REP, FOUND THE EMERGENCY LIGHT ON THE LOWER FWD LAVATORY WALL ONLY PARTIALLY ILLUMINATES-C/A-RAR THE LOWER FWD EMERGENCY EXIT LIGHT IDENTIFIER IAW EMB 175 AMM 33-50-15. RSDR DALA2019111006509Battery Pack · inoperativeEMERGENCY PATH LIGHTS SEATS 13-23 AND 31-36 INOP. R/R BATTERY PACK B5-211, BATTERY AND CHARGER B5-103 AND BATTERY AND CHARGER B5-212. OPS CHECK OK. (LP6658420)SDR SWAA2019112539090Light · loosePASSENGER CABIN SIDEWALL PANEL 231ZLW EMERGENCY EXIT LIGHTING LOOSE IN SIDEWALL. / R&R LIGHT IAW AMM.SDR YENA201911139647Light · inoperativeFT # 352, MCO-BOS. R1 DOOR EMERGENCY EXIT SIGN INOP; R & R R1 EMERGENCY LIGHT MARKER (40WL) SIGN IAW AMM 33-51-16. OK FOR SERVICE.SDR YENA201911139646Battery Pack · failedFT # 2572, SJU-TPA. CENTER FORWARD CABIN CEILING EMERGENCY LIGHT WILL NOT TEST; REPLACED EMERGENCY LIGHT POWER UNIT #2 IAW AMM 33-50-01.SDR REXA2019111391590Light · missingFORWARD GALLEY AREA MISSING EMERGENCY EXIT STRIP PATH LIGHTING ASSEMBLY.
REPLACED EMERGENCY EXIT STRIP IAW 33-51-01.SDR DALA2019111306618Power Supply · failed(AIRCRAFT 7003, L/P 1352478) WHILE PERFORMING SVC CHK, FOUND EMERGENCY LIGHTS @ SEAT ROWS 31 DEF THROUGH 40 DEF WOULD NOT GO OUT. ALSO, CEILING LIGHTS WOULD NOT COME ON. CORRECTIVE ACTION: T/S PER B777 FRM FIM 33-51-805. FOUND POWER SUPPLY M9368 BAD (SEAT ROWSSDR ASAA2019111291302Lens · detachedEXIT LIGHT COVER DETACHED IN R1 AREA. GROUNDED - YES. RE-INSTALLED EMERGENCY LIGHT COVER REF B737-900 AMM 33-51-00.SDR ASAA2019111291291Lens · detachedROW 15 EMERGENCY EXIT SIGN MISSING ITS COVER. GROUNDED - YES. REPLACED EMERGENCY EXIT SIGN @ ROW 15 IAW AMM 33-51-01. OPS CHECK NORMAL.SDR DALA2019111296591Lens · missing(LOG 6629570) DURING INSPECTION FOUND EMERGENCY EXIT SIGN COVER MISSING NEAR FLOOR BY FWD GALLEY. INSTALLED ROBBED LENS FROM A/C 3746 PER B737 AMM 33-51.SDR R61A2019111201235Power Supply · inoperativeAFT EMERGENCY EXIT SIGN WILL NOT ILLUMINATE. R&R EMERGENCY LIGHT POWER UNIT IAW 33-50-01.SDR AALA2019111209010Power Supply · no testAIRCRAFT WAS GROUNDED: HALF OF SEAT EMERGENCY LIGHTS NOT WORKING, ROW 20 THROUGH 21 INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AT LEFT SIDEWALL, EMERGENCY EXIT PER AMM 33-51-38.SDR FDEA2019111192914Battery Pack · failedMDIS 925 33-50 8137 09NOV19 DAY FACT U L1 DOOR AND LEFT SLIDE LIGHT INOP R/I 09NOV19 02:04 DAY U REASON CODE : PREMATURE REMOVAL/INSTALLATION OFF MPN: 2013-1A POS: 1 SRL: 72660 TAG NBR: H733SDR SWAA2019111138756Lamp · inoperativeR2 DOOR EMERGENCY LIGHT AFT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019111138752Lamp · inoperativeAFT L/H FUSELAGE EXTERIOR LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019111138723Charger · defectiveR/H AFT CIRCUIT BREAKER EMERGENCY LIGHT CHARGER AFT POPPED. / FOUND CHARGER DEFECTIVE. R&R CHARGER IAW AMM.SDR SWAA2019111138722Battery · defectiveR/H AFT CIRCUIT BREAKER EMERGENCY LIGHT CHARGER AFT POPPED. / FOUND BATTERY DEFECTIVE. R&R BATTERY IAW AMM.SDR CALA2019110901940Battery Pack · inoperativeTHE OVERWING EXIT LIGHTS BOTH INTERIOR AND EXTERIOR FAIL TEST DO NOT STAY LIT LONG ENOUGHSDR DALA2019111316617Light · broken(AIRCRAFT 7004, L/P 1351585) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. CORRECTIVE ACTION: FOUND EMERGENCY LIGHT COVER BROKEN. REPLACED COVER.SDR DALA2019111316616Light · damaged(AIRCRAFT 7004, L/P 1351579) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. CORRECTIVE ACTION: FOUND EMERGENCY FLOOR LIGHT COVER DAMAGED R/R COVER.SDR DALA2019111316615Light · damaged(AIRCRAFT 7004, L/P 1351577) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. CORRECTIVE ACTION: FOUND FLOOR LIGHT COVER DAMAGED AT 205 AND R/R COVER.SDR DALA2019111216614Light · damaged(AIRCRAFT 7004, L/P 1351575) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. CORRECTIVE ACTION: FOUND EMERGENCY FLOOR LIGHT COVER DAMAGED. R/R COVER.SDR DALA2019111216557Lens · damaged(AIRCRAFT 7004, L/P 1351580) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. CORRECTIVE ACTION: FOUND COVER BROKEN. REPLACED COVER.SDR DALA2019111216556Light · damaged(AIRCRAFT 7004, L/P 1351578) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. CORRECTIVE ACTION: FOUND EMERGENCY FLOOR LIGHT COVER DAMAGED. R&R COVER.SDR DALA2019111286603Lens · damagedSHIP 682 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:603. CORRECTIVE ACTION: RESECURED CKS OK. (1350379)SDR REXA2019111281588Bulb · inoperativeLIGHT ON EXIT SIGN AFT INOP
REMOVED & REPLACED BULB IAW AMM 33-51-14 & CMM 33-21-94SDR DALA2019111296594Battery Pack · inoperative(LOG 6409834) DURING INSPECTION FOUND EMERGENCY EXIT SIGNS OVER WING L/H SIDE INOPERATIVE. REPLACED POWER SUPPLY BATTERY M1694 PER B-737 MM 33-51-06. OPS CK GOOD.SDR R61A2019111208234Power Supply · inoperativeEXIT SIGN ABOVE COCKPIT DOOR DOES NOT ILLUMINATE WHEN EMERGENCY LIGHTS TESTED. R&R EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECK OK.SDR AALA201911129907Lens · missingAIRCRAFT WAS GROUNDED: EXIT LIGHT R1 INOPERABLE. MAINTENANCE FOUND EXIT LIGHT LENS MISSING AND REPLACED LENS PER AMM 33-51-00.SDR SWAA2019111138751Light · brokenFORWARD ENTRY THRESHOLD EXIT LIGHT BROKEN. / R&R LIGHT IAW AMM.SDR SWAA2019111138749Battery Pack · inoperativeR/H G4 GALLEY EMERGENCY LIGHT INOP (M1672). / R&R BATTERY PACK IAW AMM.SDR DALA2019111106537Battery Pack · inoperativeTHE FLOOR LEVEL EXIT SIGNS FOR THE LEFT AND RIGHT AFT OVERWING EXITS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AT ROW 22 PER B717 AMM 33-51. THE OPERATIONAL CHECK WAS GOOD. (LP #6108599)SDR U2RA2019111180001Lens · missingEMERGENCY EXIT LENS MISSING AT 16-17 RIGHT HAND. OKAY TO DEFER PER NATIONAL AIRLINES NEF MANUAL 25-20-01-N12, DISCREPANCY TRANSFERRED TO DEFERRED MAINTENANCE ITEM CONTROL NUMBER 191116-733. CLEAR LIGHT LENS MISSING ONLY.SDR SIMA2019111108002Lamp · inoperativeEMERGENCY EXIT CEILING LIGHT AT ROW 6/7 IS INOP-C/A-RAR EMERGENCY EXIT CEILING LAMP AT ROW 6/7 IAW EMB 140 AMM 33-50-08. OPS CHECK GOOD.
Back to JASC 3350