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 DALA2019092005461Light · inoperativeFWD GALLEY PARTITION EMER LIGHT INOP, REPLACED LIGHT ASSY.SDR SIMA20190919002Cover · brokenLT #1 EMERGENCY LIGHT FLOOR STRIP PANEL COVER BROKEN. C/A-REPLACED THE NR 1 EMERGENCY LIGHT FLOOR STRIP PANEL AFTER INSTALLING FLOOR PANEL 231GF IAW AMM 33-50-12. REINSTALLED NR 1 EMERGENCY LIGHT STRIP IAW AMM 33-50-12. OPC GOOD.SDR YENA201909190538Battery · failedFLT 391, BOS-TPA. EMERGENCY LIGHT BATTERY 12WL FAILS TEST; R & R BATTERY 12WL IAW AMM 33-51-38. OPS CKS OK.SDR DALA2019092005429Shroud · damagedDURING CRV, EMERGENCY LIGHT SHROUD DAMAGED AT SEAT 25B AND 26B. REPLACED SEAT MOUNTED EMERGENCY LIGHT SHROUD. SYSTEM OPERATION IS NORMAL. (LP 1278637)SDR MASA2019091912048Battery · dischargedALL EMER LIGHTS INOP. CHARGED BATTERIES.SDR SWAA2019092337046Battery Pack · dischargedEMERGENCY EXIT SIGN INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019092337034Cover · wornR1 DOOR LOWER EMERGENCY EXIT LIGHT MISSING DIRECTIONAL ARROW. REPLACED R1 DOOR DIRECTIONAL COVER REF SIP.SDR DALA2019091905444Battery · discharged(AIRCRAFT 654, L/P 5445381) EMERGENCY LIGHT INOP (LOC. C9) DURING SVC CHK. R/R EMERGENCY BATTERY (LOC. C9) PER AMM 33-51.SDR N6WA2019091801Light · inoperativeEMER LIGHT OVER ROW 6 INOP. REMOVED AND REPLACED EMERG FLOOD LIGHT OVER SEAT ROW6 IAW AMM 33-51-07 OPS CHECK GOOD.SDR DALA2019091805435Light · inoperativeFC CLOSET, RED PATH LIGHT INOP, INSTALLED NEW RED PATH LIGHT.SDR SWAA2019092037043Fuse · blownEMERGENCY AISLE LIGHTS AT FUSELAGE STATION 727A AND 727E F/O'S SIDE INOP. REPAIRED SOCKET AT L1065 AND RELAMPED BOTH AISLE LIGHTS PER AMM, REPLACED FUSE AT BATTERY PACK M1672 PER CMM.SDR AALA201909209005Battery · failedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT BATTERY (11WL) FAILED PS BITE CHECK. MAINTENANCE LIGHT BATTERY PER MM 33-51-38.SDR AALA201909209004Battery · dischargedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT BATTERY (10WL) FAILED PS BITE CHECK. MAINTENANCE LIGHT BATTERY PER MM 33-51-38.SDR SIMA20190918004Light · inoperativeFOURTH FLOOR EMERENCY LIGHT STRIP IS INOP FROM FORWARD SEAT. C/A-INSTALLED FOURTH FLOOR EMERGENCY LIGHT STRIP IAW AMM 33-50-12-400-801. OP CHECKED GOOD.SDR FDEA201909182278Battery Pack · dischargedMDIS 935 33-50 8397 18SEP19 ABE FACT U L1 DOOR EMERGENCY EXIT LIGHT INOP ON POST FLIGHT CHECK. FACT 18SEP19 15:33 ABE REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY PACK. REF AMM 33-51-07-2. OPS CHECK GOOD. NEW BATTERY PACK MPN -2013-1ASMI, S/N 4286SDR SWAA2019091937072Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST. R&R EMER LIGHT BATTERIES PER MM.SDR AALA201909199007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN LIGHT AT L1 DOOR INOPERABLE DURING BATTERY POWER CHECK. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201909199004Powerpack · faultedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT POWER PACK 10WL FAULTED. MAINTENANCE REPLACED POWER PACK PER 33-51-38.SDR SIMA20190918003Light · inoperative11 B/C OVERHEAD EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED OVERHEAD 11 B/C EMERGENCY LIGHT IAW AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A. OPC GOOD. END.SDR SIMA20190918002Fuse · blownEXTERNAL AFT OVERWING EMERGENCY LIGHTS INOP ON LT AND RT SIDE. C/A-REMOVED AND REPLACED F1 FUSE ON #4 BATTERY CHARGER IAW CMM 25-60-03. OPS CHECKED GOOD.SDR DALA2019091805414Powerpack · inoperative(LOG 6235934) DURING INSPECTION FOUND L1 EMER LIGHTS INOPERATIVE. R&R BATTERY POWER PACK AT L1 DOOR ENTRYWAY IAW AMM 33-51. OPS CHECK GOOD.SDR R61A201909180968Power Unit · inoperativeL1 DOOR CEILING PANEL EMERGENCY LIGHTS INOP DURING TEST. R&R ELPU ABOVE L1 DOOR IAW AMM 33-50-01, OPS CHECK GOOD.SDR DALA2019091805388Battery Pack · dischargedSEVERAL EMERGENCY EXIT LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK. OPERATIONAL CHECKS ARE GOOD REF AMM 33-51-03. (LP #5995456)SDR DALA2019092605532Lens · missing(AIRCRAFT 693, L/P 6214074) L2 DOOR EMERGENCY EXIT LIGHT COVER DIFFUSER LENS MISSING. CORRECTIVE ACTION: R/R R2 DOOR EMERGENCY EXIT LIGHT COVER PER AMM 33-51.SDR SWAA2019092437154Lens · missingR2 DOOR EGRESS LENS MISSING. R&R LENS PER MM.SDR SWAA2019092337142Light · inoperativeREPLACE LIGHT BULB IN EMERGENCY EXIT CA SIDE. R&R LIGHT ASSY PER AMM.SDR SWAA2019092337100Sign · unsecureOVERHEAD "EXIT SALIDA" SIGN BROKEN. RESECURED PER SIP.SDR SWAA2019092337067Light · inoperativeFWD EXIT SIGN LIGHT OUT. RELAMPED PER AMM.SDR SWAA2019092337065Light · inoperativeEMERGENCY LIGHT IS OUT. RELAMPED PER AMM.SDR SWAA2019092337064Light · inoperativeROW 4L BULL NOSE LIGHT IS OUT. RELAMPED PER AMM.SDR SWAA2019092337032Light · inoperativeREPLACE LIGHT BULB IN EMERGENCY EXIT CA SIDE. OK TO CONTINUE PER MEL.SDR SWAA2019092337023Light · inoperativeEXTERNAL EMERGENCY LIGHTS RT SIDE BEHIND FLAP AND AFT DOOR INOP. RELAMPED EMERGENCY LIGHTS PER AMM.SDR DALA2019091905452Light · inoperative(AIRCRAFT 5636, L/P 5891190) EXTERIOR EMERG LIGHT LEFT SIDE AFT OF WING L568 BROKEN. REPLACED LIGHT ASSY CLIP PER CMM 33-51-01. OPS CHECKS GOOD PER AMM 33-51.SDR SWAA2019091937070Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019091937045Battery · failedEMERGENCY LIGHT BATTERY FWD OF RT OVERWING EXIT FAILED CAPACITY CHECK. R&R EMERGENCY LIGHT BATTERY FWD OF RT OVERWING EXIT PER AMM 33-51-06.SDR AALA201909199002Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 10WL TEST FAILED. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR 4TXA2019091900000Battery · dischargedDURING EMERGENCY LIGHTS OPERATIONAL CHECK FOUND POWER SUPPLY BATTERY M1674 DISCHARGED.SDR AALA201909189007Socket · not seatedAIRCRAFT WAS NOT GROUNDED: SLIDE LIGHT DISAGREES WITH DOOR SLIDE ARM. MAINTENANCE FOUND R4 LIGHT SOCKET NOT SEATED AND REINSTALLED LIGHT SOCKET AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201909189005Power Supply · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT FAILED BATTERY 10WL TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 35-51-38.SDR SIMA20190917001Light · inoperative12 B/C OVERHEAD EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED 12 B/C OVERWING EMERGENCY LAMP IAW AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A. OPC GOOD. END.SDR DALA2019091805412Rccb · faultyEMERGENCY EXIT LIGHTS ARE ILLUMINATED FROM FORWARD GALLEY TO DOOR 3 ON AIRCRAFT RIGHT SIDE. REPLACED RCCB 1022XP. LP 1275893SDR DALA2019091805402Light · inoperative(AIRCRAFT 6717, L/P 5719892) MULTIPLE LIGHTS INOP AT FWD OVERWING EMER EXIT IDENTIFIER. RELAMPED LIGHTS.SDR MASA2019091712047Sign · inoperativeROW 13 OVERHEAD EMERG EXIT SIGN INOP. RESET LIGHT SYSTEM.SDR DALA2019091705386Light · missingSEAT 48G SEAT MOUNTED FLOOR PATH LIGHT MISSING. ALL OTHER FLOOR PATH LIGHTS OPERATE NORMALLY. DEFERRED PER MEL 33-50-07A UNTIL NEW SEAT MOUNTED EMERGENCY LIGHT IS AVAILABLE TO INSTALL. LP 5417102SDR DALA2019091705361Battery Pack · dischargedFWD OVERWING EXIT EMERGENCY EXIT LIGHTS INOP AT ROW 24. REPL BATTERY PACK PER AMM 33-53. OPS CHECK GOOD. (LP5588474)SDR CALA2019091701560Battery Pack · dischargedEMERGENCY LIGHT CAPACITY TEST FND 2L-3L 2R-3R FLOOR EMER LIGHT ILLUMINATE TIME LESS THAN 15 MIN SPEC NR B777-33-3-7019 REF NON-ROUTINE NR 9483889. REPLACED R2 DOOR THE EMERGENCY LIGHT POWER SUPPLY BATTERY PACK, AND PERFORMED THE TEST, THE RESULT FOUND NORMAL RSDR CALA2019091701559Charger · inoperativeEMERGENCY LIGHT CAPACITY TEST FND 3R-4R FLOOR, AND CEILING EMERGENCY LIGHT ILLUMINATE TIME LESS THAN 15 MIN SPEC NR B777-33-3-7019 REF NON-ROUTINE NR 9483892. R4 DOOR REPLACED EMERGENCY LIGHT POWER SUPPLY CHARGER AND PERFORMED THE TEST, THE RESULT FOUND NORMALSDR CALA2019091701558Battery Pack · dischargedEMERGENCY LT CAPACITY TEST FND L4 CEILING EMERGENCY LIGHT ILLUMINATE TIME LESS THAN 15 MIN SPEC NR B777-33-3-7019 REF NON-ROUTINE N O.9483874. REPLACED DR L4 THE EMERGENCY LIGHT POWER SUPPLY CHARGER AND BATTERY PACK, AND PERFORMED THE TEST. THE RESU LIGHT FOUNSDR SWAA2019092537029Light · missingG1 GALLEY EXIT LIGHT MISSING. INSTALLED LIGHT IAW AMM.SDR SWAA2019091937036Light · inoperativeRT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED RH EMERGENCY LIGHT PER AMM 33-21-00.
Back to JASC 3350