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 DALA2019102806190Battery Pack · inoperativeAFT CABIN EMERGENCY LIGHTS NOT ILLUMINATED WHEN TESTED ON SVC CHECK. REPLACED EMER LIGHT BATTERIES AND FUSE PER MD88 AMM 33-53. FOUND NORMAL OPERATION WHEN TESTED. (LP5587087)SDR AALA2019103089007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: DURING WALK AROUND FOUND DOOR 1R SLIDE LAMP INOPERATIVE. SUPPLEMENTAL TO UPDATE SECTION 4 AND SECTION 5. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06. (CLOSED)SDR SWAA2019102938357Lamp · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR CALA2019102901850Battery Pack · no testSEAT ROWS 20-34 L/H AND R/H EMERGENCY LIGHT BATTERY PACKS FAIL CAPACITY CHECKSDR SWAA2019102838244Lamp · inoperativeL2 DOOR OUTSIDE EMERGENCY LIGHT INOP. / R&R LAMP PER AMM.SDR SWAA2019102838242Light · looseL/H FLOOR TRACK LIGHTING AT ROW 8 AREA PULLED UP FROM FLOOR. / SECURED PHOTO LUMINESCENT STRIP IAW AMM.SDR MASA2019102712110Bulb · inoperativeROW 15 CEILING EMER LIGHT INOP
REPLACED BULBSDR DALA2019102706182Charger · inoperativeOVERWING EXIT LIGHTS ABOVE FWD OVERWING DOORS LT AND RT SIDE INOP. REPLACED BATTERIES IN BATTERY CHARGER FOR EMERGENCY LIGHTS. CKS GOOD. (LP6641857)SDR DALA2019103096296Lens · unsecureSHIP 6806 EXIT SIGN OVER 2L DOOR FALLING OFF. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT LENSE ABOVE L2 DOOR. (1332344)SDR DALA2019102986248Sign · detached(AIRCRAFT 6806, L/P 5757274) EXIT SIGN OVER 2L DOOR FELL OFF. CORRECTIVE ACTION: RESECURED EXIT SIGN OVER 2L.SDR DALA2019102986247Battery Pack · inoperative(AIRCRAFT 6822, L/P 6532900) WHILE PERFORMING MTC FOUND EMER EXIT LIGHT OUTS AT ROWS 36-40. CORRECTIVE ACTION: R/R BATTERY PACK AT ROW 36ABC IAW B757 AMM 33-51.SDR DALA2019102866218Cover · missingFWD AND AFT R/H CABIN DOORS MISSING EMERGENCY LIGHT COVERS, INSTALLED COVERSSDR DALA2019102806197Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1210 FOUND INOPERATIVE DURING SERVICE CHECK. REPLACED BATTERY PACK M1210 SYSTEM OPERATION IS NORMAL.SDR SWAA2019102838245Light · looseL/H EMERGENCY LIGHT STRIP BETWEEN SEAT 11 TO SEAT 12 LOOSE ON FLOOR. SECURED EMERGENCY LIGHT STRIP PER SIP.SDR SIMA201910286001Sign · inoperativeDURING PS-2 FOUND RH EXIT MARKING SIGN INOP-C/A-INSTALLED RH EXIT MARKING SIGN ASSEMBLY IAW EMMB 145 AMM 33-50-14 OPS CHECK GOOD.SDR JJBA201910286010Inverter · inoperativeEMERGENCY EXIT LIGHTS AT SEAT 18ACD ARE OUT. OVERHEAD AFT LIGHT, BOTH SIDEWALL LIGHTS AT 18A AND UPPER SIDEWALL LIGHT AT 18D, ALONG WITH SIDEWALL LIGHTS AT 18D ARE OUT. REMOVED AND REPLACED L/H INVERTER ASSEMBLY (#4), OPS CHECK FAIL. REMOVED AND REPLACED #3 & SDR DALA2019102706183Battery Pack · inoperativeFOUND ROWS 1-4 CIELING EMERGENCY LIGHTS INOP. R&R BATTERIES AT BATTERY PACK B5-100. CHECKS OK. A/C OK FOR SVC. REF MD-88 AMM 33-53. (LP5587492)SDR DALA201910306274Light · cracked(AIRCRAFT 7101, L/P 1332259) FLOOR PROX EMER LTS FOUND CRACKED AT EXTERIOR OF OFCR, OFAR AND GLY. CORRECTIVE ACTION: FLOOR PROX EMER LTS REMOVED AND REPLACED AS PER B777 AMM 33-51-05.SDR YENA2019102950621Power Supply · malfunctionedDURING HEAVY MAINTENANCE, EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL LOW VOLTAGE NOTED ON OPS CHECK; REF LHT NR 5200000685-005000922310-0010 - REPLACED EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL IAW A321 AMM 33-51-38-000-001-A REV 79. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019102950620Power Supply · malfunctionedDURING HEAVY MAINTENANCE, EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL LOW VOLTAGE NOTED ON OPS CHECK; REF LHT NR 5200000685-005000922310-0010 - REPLACED EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL IAW A321 AMM 33-51-38-000-001-A REV 79. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019102950619Power Supply · malfunctionedDURING HEAVY MAINTENANCE, EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL LOW VOLTAGE NOTED ON OPS CHECK; REF LHT NR 5200000685-005000922310-0010 - REPLACED EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL IAW A321 AMM 33-51-38-000-001-A REV 79. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019102950618Power Supply · malfunctionedDURING HEAVY MAINTENANCE, EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL LOW VOLTAGE NOTED ON OPS CHECK; REF LHT NR 5200000685-005000922310-0010 - REPLACED EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL IAW A321 AMM 33-51-38-000-001-A REV 79. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019102950617Power Supply · malfunctionedDURING HEAVY MAINTENANCE, EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL LOW VOLTAGE NOTED ON OPS CHECK; REF LHT NR 5200000685-005000922310-0010 - REPLACED EPSU'S 10WL, 11WL, 12WL, 13WL, 14WL IAW A321 AMM 33-51-38-000-001-A REV 79. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR CALA2019102981837Battery Pack · inoperativeEMERG EXIT LTS BOTTOM AFT LAV DOOR D INOP MEL REQUESTED MEL 3319E MX WORKING REMOVED AND REPLACED EMERGENCY BATTERY PACK BATTERY ABOVE LAV D AND FUSE.OPS CHKS NORMAL. (FUSE PN# 276005)SDR ASAA2019102853134Sign · missingEXIT SIGN MISSING R2 DOOR. GROUNDED - YES. REMOVED AND REPLACED EXIT SIGN AT R2 DOOR AS REQUIRED. OPS NORMAL, NO OTHER DEFECTS FOUND AT THIS TIME. GOOD FOR SERVICE. REF AMM 11-31-01.SDR DALA2019102856216Battery Pack · faultedEMERGENCY LIGHT CHECK - EPSU AFT LEFT BATT FAULT, REPLACED EPSU 13WL BATTERYSDR SWAA2019102838324Battery Pack · inoperativeR/H OVERWING EMERGENCY ESCAPE GROUND LIGHTS INOP. / R&R POWER SUPPLY BATTER PACK IAW AMM & WDM.SDR SWAA2019102838323Battery Pack · inoperativeL/H OVERWING EMERGENCY ESCAPE GROUND LIGHTS INOP. / R&R POWER SUPPLY BATTER PACK IAW AMM & WDM.SDR SWAA2019102838322Battery Pack · inoperativeL/H EMERGENCY LIGHTS INOP AT SEAT ROW 9. / R&R POWER SUPPLY BATTER PACK IAW AMM & WDM.SDR SWAA2019102838317Battery Pack · inoperativeL/H EMERGENCY LIGHTS INOP AT SEAT ROW 12. / R&R POWER SUPPLY BATTER PACK IAW AMM & WDM.SDR SWAA2019102838316Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. / R&R BATTERY PER AMM.SDR SIMA201910285003Bulb · inoperativeL/H CENTER FAIRING EXT EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED L/H CENTER FAIRING EXT EMERGENCY LIGHT BULB IAW EMB I45 AMM 33-50-10 OPS CHECK GOOD NO FURTHER DEFECTS NOTEDSDR SIMA201910285002Light · inoperativeEMERGENCY LIGHT ABOVE LH WING INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT ABOVE LH WING IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD.SDR HNAA2019102800325Inverter · inoperativeNDIS 686 33-50 0016490 25OCT19 SBY CLOSE
ROW 12BC EMERGENCY EXIT LIGHT ON SIDEWALL INOP
21611 00 CRH
FACT 25OCT19 08:20 SBY
R&R'ED EMERG LT. INVERTOR IRW AMM 33=50=11SDR DALA2019102866192Diode · failed(LOG 6361262) DURING INSPECTION FOUND DURING TASK EMERG LIGHT CHECK, FOUND LIGHTS INOPERATIVE FROM SEAT ROW 23 TO SEAT ROW 31. FOUND BURNED DIODE INSIDE BATTERY PACK M01672 REPLACED DIODE OPS CHECK GOOD, IAW B737 AMM 33-51.SDR HNAA2019102800324Inverter · inoperativeNDIS 643 33-50 0015130 25OCT19 SBY CLOSE
EMERGENCY EXIT SIGN ABOVE F/A SEAT DOES NOT ILLUMINA
TE
33384 00 BAD
FACT 25OCT19 12:08 SBY
TROUBLESHOT IAW FIM TASK 33-50-00-810-804SDR DALA2019102506179Connector · unsecureEMERGENCY LIGHTS INOPERATIVE AT SEATS 12,2 13, 14, 15B AND 31B. RESECURED CONNECTION AT 31A, AND 14A.SDR SWAA2019102538184Sign · detachedR/H SIDE OVER WING EXIT, EXIT SIGN FELL OFF. / SECURED EXIT SIGN IAW AMM.SDR MASA2019102512108Lamp · inoperativeLWR FWD EXIT LIGHT AT PAX DOOR INOP. RELAMPEDSDR MASA2019102512107Bulb · inoperativeROW 14 RHS EMER EXIT SIGN-2 BULBS OUT. RELAMPEDSDR YENA2019102940625Lamp · burned outFT # 1348, SJU-DCA. FWD BULKHEAD AT 1ABC RED EMER LIGHT ASSY BURNT OUT; RELAMPED PER AMM 33-51-18. OP CHK GOOD. OK FOR SVC.SDR DALA2019102856212Lens · looseSHIP 6806 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:603. CORRECTIVE ACTION: RESECURED LENS. CHKS GOOD. (1330179)SDR SWAA2019102838325Battery Pack · no testCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01675. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019102838315Battery Pack · no testCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01669. / R&R BATTERY PACK PER AMM AND DWG.SDR AALA201910259017Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY CEILING LIGHTS AT SEAT 17 AND 19 DEGH WERE INOPERABLE. REPLACED CEILING LIGHT PER AMM 33-51-03.SDR SWAA2019102538240Battery Pack · inoperativeR/H EMERGENCY LIGHT INOP AT ROW 6. / R&R BATTERY PACK PER AMM.SDR SWAA2019102538239Battery Pack · inoperativeR/H EMERGENCY LIGHT INOP AT ROW 3. / R&R BATTERY PACK PER AMM.SDR SWAA2019102538234Battery Pack · no testL/H AFT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2019102538233Battery Pack · no testR/H OVER WING EXIT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2019102538232Battery Pack · no testL/H OVER WING EXIT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.
Back to JASC 3350