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 SWAA2019071935008Battery Pack · dischargedFORWARD AREA EMERGENCY LIGHTNING SIGNS BATTERIES EXHAUSTED AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR YENA201907130404Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES AT 11WL, 12WL AND 13WL; REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT FIN # 11WL, 12WL AND 13WL PER AMM 33-51-38.SDR YENA201907130403Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES AT 11WL, 12WL AND 13WL; REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT FIN # 11WL, 12WL AND 13WL PER AMM 33-51-38.SDR YENA201907130402Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES AT 11WL, 12WL AND 13WL; REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT FIN # 11WL, 12WL AND 13WL PER AMM 33-51-38.SDR I5EA20190705Power Supply · inoperativeDISCREPANCY: RT AFT EMERGANCY EXTERNAL LIGHT INOP. CORRECTIVE ACTION: TROUBLE SHOT EMERGANCY LIGHT SYSTEM PER WDM 33-51-14 FOUND THE EXTERNAL EMERGANCY LIGHT POWER SUPPLY ASSY INOP TO AFT EXTERNAL LIGHT. REMOVED AND REPLACED POWER ASSY IAW AMM 35-51-06. OPS TSDR DALA2019071504279Lens · missingSHIP 5651 OVERWING EXIT PLACARD IS MISSING-LOC 25A. CORRECTIVE ACTION: REPLACED LENS AS REQUIRED. REF AMM 33-51. (5927092)SDR SWAA2019071634817Battery · dischargedFORWARD EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2019071634877Charger · inoperativeR2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY CHARGER PER AMM.SDR SWAA2019071634876Charger · inoperativeL1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY CHARGER IAW MM.SDR SWAA2019071634875Battery · dischargedL1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY IAW MM.SDR SWAA2019071634874Battery · dischargedLT EMERGENCY LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R BATTERY IAW MM.SDR SWAA2019071634824Battery · dischargedR2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR SWAA2019071634820Charger · inoperativeLT EMERGENCY LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R BATTERY CHARGER IAW MM.SDR DALA2019071504250Battery Pack · dischargedON SVC CHECK FOUND EMERGENCY LIGHTS AT ROWS 35 CDE, 37 CDE AND AFT GALLEY EMERGENCY LIGHTS INOP. R+R EMERGENCY LIGHTS BATTERY PACK AT B5-237 AND CHARGER PER AM 33-51. OPS CKS OK. A/C OK FOR SVC. (LP# 5049562)SDR SIMA20190713005Light · inoperativeDURING PS-2 CHECK, FOUND EXTERNAL EMERGENCY LIGHT ON THE LEFT HAND SIDE CENTER FAIRING WILL NOT ILLUMINATE. C/A-FOUND LAMP TP BE BURNT OUT. REMOVED AND REPLACED LAMP IAW AMM 33-50-10. OPS CHECK GOOD.SDR AALA201907159022Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER AT 1L DOOR MISSING. MAINTENANCE REPLACED LIGHT PER AMM 33-50-00.SDR AALA201907149013Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT MOUNTED ON 34 ABC INOPERABLE. MAINTENANCE REPLACED LIGHT PER AMM 33-51-18.SDR 29GA2019071500002Light · unsecureFLIGHT 0112 EYW/FLL REPORT: FLIGHT ATTENDANT REPORTS EMERGENCY EXIT LIGHT OVER SEAT 3A INOP. CORRECTIVE ACTION: RESECURE EMERGENCY EXIT LIGHT IAW AMM 33-50-55, OPS CHECK GOOD.SDR 29GA2019071500004Circuit Breaker · trippedFLIGHT 0105, IN FLIGHT C/B L7 EMERGENCY LIGHT POWER AND L8 EMERGENCY LIGHT CONTROL TRIPPED. RESET C/B'S L7 EMERGENCY LIGHT POWER AND L8 EMERGENCY LIGHT CONTROL IAW MM-O1 4.15 NO DEFECT NOTED AT THIS TIME.SDR SWAA2019071634871Fuse · blownSUPPLEMENTAL INFORMATION, EMERGENCY EXIT DOOR LIGHT INOP. R&R FUSE PER AMM.SDR SWAA2019071634815Fuse · blownSUPPLEMENTAL INFORMATION, RT WING OVERHEAD EXIT SIGN LIGHT INOP AT ROW 12. R&R FUSE PER AMM.SDR DALA2019071504270Lens · damaged(AIRCRAFT 7007, L/P 1168520) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:901 / INTERIOR. REPLACED LENS AT EMERGENCY LIGHT 901. OK FOR SVC PER MM 33-50.SDR SWAA2019071634828Battery Pack · failedEMERGENCY BATTERY POWER SUPPLY M1672 FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019071634873Battery Pack · dischargedEMERGENCY BATTERY PACK INOP AT M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019071634872Battery Pack · dischargedEMERGENCY BATTERY PACK INOP AT M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019071634841Battery Pack · inoperativeEMERGENCY BATTERY PACK INOP AT M1673. R&R BATTERY PACK PER AMM.SDR SWAA2019071634809Sign · brokenAFT CABIN CENTER EMERGENCY EXIT SIGN BROKEN. R&R SIGN IAW AMM.SDR SWAA2019071634806Light · inoperativeLT EMERGENCY AISLE LIGHT INOP AT SEAT ROW 17. R&R BULB IAW AMM.SDR ASOA201907125085Inverter · inoperativeDURING MX INSPECTION THE AFT EMERGENCY LIGHT STRIPS 6,7, AND 8 INOP. MX R&R #6 INVERTER WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019071534803Light · inoperativeLT AFT EMERGENCY LIGHTING STRIPS INOP. R&R STRIP PER MT.SDR SWAA2019071534802Light · inoperativeRT FORWARD EMERGENCY LIGHTING STRIPS INOP. R&R STRIP PER MT.SDR SWAA2019071534801Light · inoperativeRT AFT EMERGENCY LIGHTING STRIPS INOP. R&R STRIP PER MT.SDR SCNA20190712108Battery Pack · dischargedPART OF EMERGENCY LIGHTS ILLUMINATTED IN AIRCRAFT WITH SWITCH IN ARMED GARDED POSITION. OVERHEAD BIN EMERGENCY LIGHTS AT ROWS 6 & 11ABC INOP. REMOVED AND REPLACED LT AFT EMER BATTERY PACK. OK FOR SERVICE. ALSO REMOVED AND REPLACED BATTERY PACK AT LT OVER WING SDR 29GA2019071500005Light · unsecureFLIGHT# 0084 ELH/FLL REPORT: EMERGENCY LIGHT SWITCH BULB INOP. CORRECTIVE ACTION: SECURED EMERGENCY BULB, OPS CHECK OK IAW AMM 33-50-00.SDR AALA201907159024Battery Pack · dischargedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS FROM SEATS ROW 26 TO ROW 40 INOPERABLE ON BOTH SIDES. MAINTENANCE REPLACED POWER SUPPLY BATTERY PACK PER MM 33-51-06.SDR AALA201907159023Battery Pack · dischargedAIRCRAFT WAS GROUNDED: EMERGENCY AISLE CEILING LIGHTS ABOVE SEATS 26J AND 29J INOPERABLE. MAINTENANCE REPLACED POWER SUPPLY BATTERY PACK PER MM 33-51-06.SDR 29GA2019071500001Power Supply · failedFLIGHT# 0098 MCO/MHH REPORT: LEFT AFT EMERGENCY LIGHT INOP. CORRECTIVE ACTION: R&R AFT LEFT POWER SUPPLY IAW AMM 33-50-10-04 OPS CHECK GOOD.SDR RAIA201907120002Light · inoperativeMAIN DOOR EMERGENCY LIGHT LOCATED ON BOTTOM OF THE PLUG DOOR HINGE, IS INOP. R/R LIGHT BULB ON MAIN DOOR EXTERNAL EMERGENCY LIGHT ASSY.OPS CHECK GOOD.SDR MASA2019071211947Power Supply · inoperativeCOCKPIT EMER LIGHTS INOP. REPLACED EMERG LIGHT POWER SUPPLY UNIT.SDR DALA2019071204192Light · inoperativeLT AFT OVERWING EXIT DOOR PULL HANDLE LIGHT INOP, RELAMPED LT AFT OVERWING EXIT DOOR PULL HANDLE LIGHT.SDR DALA2019071204162Fuse · blownFOUND 1ST CLASS EMERG LIGHTS INOP. R/R BATTERY TRAY FUSES OPS GOOD REF AMM 33-53. (LP5774496)SDR VNAA2019071111103Sign · inoperativeRIGHT SIDE EMERGENCY EXIT DOOR LIGHT INOP. REMOVED & REPLACED R/H LIGHTED FLOOR-LEVEL EXIT SIGN OPS CHECK GOOD.SDR DALA2019071604293Light · inoperativeL1 DOOR EMERGENCY LIGHT AND SEATS 36AB AND 27FG ARE INOPERATIVE. REPLACED BURNT BULBS. SYSTEM OPERATION IS NORMAL.SDR DALA2019071804288Cover · missingTHE EMERGENCY EXIT SIGN COVER IS LOOSE AT LOCATION: 6.2 INTERIOR. UPON ARRIVAL MAINTENANCE DISCOVERED THAT THE EMERGENCY EXIT SIGN COVER WAS MISSING. THE EXIT SIGN COVER WAS REINSTALLED AND THE OPERATIONAL CHECK WAS GOOD PER AMM 25-60. (LP #1167004)SDR SWAA2019071734942Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT ABOVE INOP. R&R LIGHT IAW AMM.SDR SWAA2019071734863Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LIGHT ABOVE INOP. R&R BATTERY PACK IAW AMM.SDR DALA2019071304227Sign · inoperativeSHIP 5654 EMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS:604. CORRECTIVE ACTION: EXIT SIGN IS ACTUALLY AT R2. REATTACHED EMERG EXIT SIGN AT R2 DOOR OVERHEAD.SDR CALA2019071301184Powerpack · failedSUPPORT TASK - EA 2500-04866 M33407 EMERGENCY POWER PACK CAPACITY CHECK FOUND FAIL REF NR LP 9131820 M33407 EMERGENCY POWER PACK REPLACED AND TEST NORMAL AS PER AMM 33-51-06.SDR CALA2019071301182Light · inoperativeREF. N/R : 99842689 EMERGENCY LIGHTS INOP FROM ROW 21 TO 32. DATA WAS TRANSCRIBED FROM PAPER DOCUMENT : N/R 99842689 WORK ACCOMPLISHED BY MECHANIC, INSPECTED BY Q.C. REMOVED AND REPLACED BATTERY PACK AT M676, M671 AND RELAMPED ROW 21, RESECURED CONNECTOR POWESDR CALA2019071301180Battery · failedSUPPORT TASK - EA 2500-04866 M33424 EMERGENCY POWER PACK CAPACITY CHECK FOUND FAIL REF NR LP 9131819 M33424 EMER PWR PACK BATTERY REPLACED & TEST OKAY IAW AMM 33-51-06.
Back to JASC 3350