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 CALA2019083001448Battery · discharged10WL BATTERY CAPACITY LOW P/N:3214-31, PERFORMED BY EMP V903217,REPLACED 10WL EPSU BATTERY PACK & C/OUT OPERATIONAL TEST FND THE RESULT NORMAL AS PER AMM 33-51-38-000/ 400-002A & AMM 33-51-00-710-001C1 REV102.SDR SWAA2019082936419Lens · crackedMAIN CABIN COMPARTMENT L/H STOW BIN EMERGENCY LIGHT LENS CRACKED AT 17. R&R LENS IAW AMM.SDR SWAA2019082936418Lens · crackedMAIN CABIN COMPARTMENT L/H STOW BIN EMERGENCY LIGHT LENS CRACKED AT ROW 14. / R&R LENS IAW AMM.SDR SWAA2019082936417Lens · crackedMAIN CABIN COMPARTMENT L/H STOW BINS EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 6 TO ROW 7. R&R LENS IAW AMM.SDR SWAA2019082936416Lens · crackedMAIN CABIN COMPARTMENT L/H STOW BIN EMERGENCY LIGHT LENS CRACKED AT ROW 4. / REPAIRED LENS IAW AMM.SDR DALA2019082805048Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHT IN-OP ATL1 DOOR EXTERIOR AND EXIT SIGN. REPLACED BATTERY PACK D10750 PER AMM 33-51. OPS CKS GOOD.SDR REXA2019082861274Light · inoperativeLH AFT WING ROOT EMERG LIGHT INOP. R&R EMERG LIGHT IAW AMM 33-51-15. OPS CHECK GOOD.SDR IPXA2019082876060Switch · failedEMERGENCY LIGHT SWITCH INOP. R&R'D CONT PNL PER AMM 33 51 08. OS CHK GOOD. IPC 32 51 08 01A, 010SDR SWAA2019082836391Fuse · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R LIGHT FUSE PER AMM.SDR SWAA2019082836388Fuse · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE BALLAST FUSE IAW AMM.SDR SWAA2019082836386Light · detachedR1 DOOR EMERGENCY EXIT SIGN FELL OFF. R & R THE LIGHT ASSEMBLY HOUSING IAW MM.SDR SWAA2019082836366Cover · detachedEMERGENCY EXIT SIGN ON CEILING OF CABIN FELL OFF. SECURED THE LIGHT COVER IAW SIP.SDR SWAA2019082736340Lens · looseAFT OVERHEAD EMERGENCY EXIT SIGN LOOSE. / SECURED LIGHT LENS IAW AMM.SDR AALA201908279043Power Supply · inoperativeAIRCRAFT WAS GROUNDED: PERIODIC SERVICE CHECK OF OPERATIONAL TEST OF EMERGENCY LIGHTS FAULT EPSU (13WL) AFT L/DEU B (300RH7). REMOVED AND REPLACED EPSU 13WL IAW AMM 33-51-38 FOR TROUBLESHOOTING. IAW AMM 33-51-38.SDR AALA201908279044Light · inoperativeAIRCRAFT NOT GROUNDED: L/H AFT SERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED L/H AFT SERVICE DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-16. OPS CHECK GOOD IAW AMM 33-51-16.SDR AALA201908279053Lens · brokenAIRCRAFT IN BASE VISIT: DOOR 4R EMER EXIT MARKER LIGHT LENS BROKEN. REMOVED AND REPLACED DOOR 4R EMER EXIT LIGHT ASSY IAW AMM33-51-16-000-001/-400-001. OPS TEST IAW AMM 33-51-00-400-001 OK.SDR DALA2019082704978Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING IN CABIN SECTIONS ARE INOP. RELAMPED SEVERAL LIGHTS THAT HAD INCORRECT BULBS. RPLD BATTERY PACK AT ROW 12 PER MD88 AMM 33-53. LIGHTS NOW CK GOOD. (LP5375862)SDR DALA2019082704977Battery Pack · inoperativeDURING SVC FOUND AFT O/W EXIT SIGNS INOP. R/R AFT O/W EXIT SIGN BATTERIES PER MD88 M/M 33-53 OPS CHECK GOOD. (LP5966705)SDR KCSA201908261202Light · inoperativeEMERGENCY LIGHTS UPPER DECK AFT, CENTER & LEFT INOPSDR KCSA201908261201Light · inoperativeEMERGENCY LIGHT IN MAIN DECK CEILING BY L1 DOOR INOPSDR QXEA2019082600330Light · looseEMERGENCY EXIT FLOOR PATH STRIP AT MCD PULLED FROM FLOOR. DURING RON ARRIVAL CHECK FOUND FLOOR EMERGENCY EXIT STRIP AT MCD BETWEEN WET FLOOR & CARPET LIFTED OFF. WET FLOOR SEAL NOT DAMAGED. REMOVED EXIT STRIP CLEANED SURFACE & INSTALLED NEW EXIT STRIP. APPLIEDSDR VNAA2019082511101Light · inoperativeMX FOUND 3 EMERGENCY LIGHT BY FWD SERVICE DOOR WILL NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY LIGHT. OPS CHECK GOOD.SDR YENA2019083025484Battery · failedFT # 1468, DURING OPS CHK PER TC# A320-25-62-47-400-001-A WO # 1011184 FOUNG EPSU BATT OF FWD L (10WL), EPSU BATT OF MIID L (15WL) AND ESCAPE SLIDE AFT LH AT FAULT; R & R EPSU BATT AT FWD L, MID L & AFT L. R/R AFT L (13WL) EPSU. R/R AFT LEFT ESCAPE SLIDE. ALSDR YENA2019083025483Battery · failedFLT 1468, DURING AN OPS CHECK IAW TC A320-25-62-47-400-001-A, FOUNG EPSU BATTERY OF FWD LT 10WL EPSU BATT OF MIID L (15WL) AND ESCAPE SLIDE AFT LH AT FAULT; R & R EPSU BATT AT FWD L, MID L & AFT L. R/R AFT L (13WL) EPSU. R/R AFT LEFT ESCAPE SLIDE. ALL FAULT SDR YENA2019083050482Battery Pack · inoperativeFLT 1468, DURING OPS CHECK IAW TC A320-25-62-47-400-001-A, FOUND BATTERIES FOR POWER SUPPLIES 10WL, 15WL AND ESCAPE SLIDE AFT LT AT FAULTED. R & R THE BATTERIES AND AFT LEFT ESCAPE SLIDE. ALL FAULTS CLEARED. ALL IAW AMM 25-62-44 & 33-51-38.SDR SWAA2019082936407Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK M1669 DID NOT CHARGE. R&R BATTERY PACK M1669 PER AMM.SDR DALA2019082865052Lens · damagedDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. INSTALLED AFT EMERGENCY EXIT OVERHEAD SIGN LENS PER AMM 33-50. OPS CK GOOD.SDR DALA2019082865043Battery Pack · inoperativeDURING INSPECTION FOUND AFT RT EXIT EMERGENCY LIGHTS AND AFT RT 9 SEAT ROW EMERGENCY FLOOR LIGHTS EXTINGUISH AFTER 10 SECONDS.REMOVED & REPLACED AFT BATTERY PACK LOC M01672 PER B737 AMM 33-51. OPS CHECKED GOOD.SDR AALA201908279031Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENY LIGHT BATTERY FAULT DURING TEST. TWO EMERGENCY LIGHTS AFT OF EXITROW ARE TURNING ON AND OFF DURING TEST. REMOVED AND REPLACED FWD LH EMER BATT PWR UNIT, IAW AMM 33-50-01/400.SDR SWAA2019082766302Charger · inoperativeR1 DOOR EMERGENCY LIGHT INOP. R&R CHARGER PACK ASSEMBLY IAW AMM.SDR RAIA2019082640001Bulb · inoperativeMAIN CBIN DOOR EMERGENCY FLOOD LIGHT #1 INOPERATIVE. REMOVED AND REPLACED BULB IN EMERGENCY LIGHT OPS CHECKED GOODSDR ASAA2019082653489Lens · brokenFOUND R/H AFT WING EXIT EMERGENCY LIGHT LENS BROKEN. GROUNDED - YES. REPLACED LIGHT LENS, OPS CK NML REF AMM 33-51-00-710-801.SDR SIMA201908265001Inverter · inoperativeCENTER AISLE EMERGENCY LIGHT SYSTEM IS INOP. REMOVED AND REPLACED THE NR 5 DC/AC INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR DALA2019082604971Sign · inoperativeEMERGENCY EXIT SIGN INOP AT 4R, RE-INSTALLED EMERGENCY EXIT SIGN AT 4R.SDR HNAA2019082600238Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOP. REPLACED RH EMERGENCY LIGHT IAW AMM 33-50-10-000/400-801-A. OPS CHECK GOODSDR MASA2019082512019Light · inoperativeENTRY EMER LIGHT FLOOR LVL INOP. REPLACED LIGHT ASSY.SDR AALA2019082769003Light · inoperative51-18-600-001/-400-001. OPS CK IAW AMM 33-51-00-710-001.SDR DALA2019082965066Battery Pack · inoperativeFOUND RIGHT CEILING EMERGENCY LIGHTS FROM SEATS 18-29 AND EXIT SIGN ABOVE MID LAV INOPERATIVE. REPLACED BOTH BATTERY AND POWER PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2019082805051Light · inoperativeDURING INSPECTION FOUND EMERGENCY AISLE LIGHT ABOVE ROW 1 INOPERATIVE. REMOVED AND REPLACED EMER LIGHT ASSY ABOVE ROW 1 PER B717 AMM 33-22 OP CKS GOOD.SDR YENA2019082840480Lamp · inoperativeFLT 2824, EMERGENCY LIGHT AT ROW 11 ABC INOPERATIVE. RELAMPED EMERGENCY LIGHT AT ROW 11 ABC I.A.W. AMM 33-51-18 OPS CHECK GOOD.SDR UIEA2019082865291Fuse · blownEMERGENCY LIGHTS IN ROW 30 THRU 40, SEATS ROWS A AND C INOP. REPLACED A BLOWN FUSE IN POWER SUPPLY 9010 AND REPAIRED CHAFED WIRES AT SEAT 31A IAW AMM 33-59-00.SDR DALA2019082805022Light · inoperativeEMERGENCY LIGHT AT SEAT 42G INOPERATIVE. DEFERRED PER MEL 33-50-07A UNTIL THE SEAT WIRE HARNESS IS AVAILABLE TO REPLACE. LP 6214294SDR R61A2019082740864Battery · no testLH FWD LWR EMERGENCY LIGHT INOP ON TEST. R&R FWD RH EMERGENCY LIGHT BATTERY REF AMM 33-50-01.SDR SWAA2019082736312Light · missingL2 DOOR AFT WALL EMERGENCY EXIT LIGHT MISSING. REINSTALLED LIGHT PER AMM.SDR SWAA2019082736299Lens · detachedR/H EMERGENCY EXIT SIGN SIDE OVERWING DETACHED FROM WALL. R&R EMERGENCY EXIT LENS IAW SIP.SDR SWAA2019082736265Light · peelingL/H PHOTOLUMINESCENT STRIP PEELED BETWEEN ROWS 7 TO ROW 8. / SECURED STRIP PER AMM.SDR AALA2019082769004Light · inoperativeAIRCRAFT IN BASE VISIT: LAV H EMERGENCY LIGHT ON SIDE PANEL DAMAGED. REMOVED AND REPLACED LAV H EMER LIGHT IAW AMM 33-51-18-000-001/-400-001. OPS CK IAW AMM 33-51-00-710-001.SDR AALA201908279019Light · inoperativeAIRCRAFT NOT GROUNDED: PHOTOLUMINESCENT FLOOR PATH EXIT LIGHTING INOP ON RH SIDE OF CABIN FROM FWD GALLE TO ROW 11. REMOVED AND REPLACED PHOTOLUMINESCENT FLOOR PATH EXIT LIGHTING IAW AMM 33-51-15. OPS CHECK GOOD.SDR AALA201908279023Light · inoperativeAIRCRAFT NOT GROUNDED: PHOTOLUMINESCENT LIGHT STRIP REQUIRE EXIT MARKING PLACARD AT FWD GALLEY & ROW 11. INSTALLED EXIT MARKINGS ROW 11 TO GALLEY, RIGHT SIDE.SDR AALA201908279034Light · inoperativeAIRCRAFT IN BASE VISIT: LAV D EMERG LIGHT ON DOOR INOPERATIVE. REMOVED AND REPLACED LAV D EMERGENCY LIGHT ON DOOR IAW AMM 33-51-18-000-001-A AND AMM 33-51-18-400-001-A. OPS CHECK GOOD.
Back to JASC 3350