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 SWAA2019040531400Battery · no testL/H FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PER AMM.SDR YENA2019040530176Battery Pack · no testEMERGENCY LIGHT TEST FAILED AT 10WL. REMOVED & REPLACED FWD EMERGENCY LIGHT BATTERY FIN 10WL IAW AMM 33-51-38.SDR AALA201904059007Power Supply · failedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU SYSTEM FAIL (15WL) MID L. REMOVED AND REPLACED BATTERY AT 15WL CIDS EPSU IAW AMM 33-51-38. OPS CHECK OK.SDR DALA2019040402212Battery Pack · inoperativeEXIT LIGHTS BY 4L DOOR INOPERATIVE. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SWAA2019040431384Battery Pack · no testEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019040431355Battery Pack · no testEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01670. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019040431351Light · inoperativeR/H FORWARD CABIN PHOTOLUMINESCENT LIGHT STRIP INOP BETWEEN BS. 335 TO BS. 353. R&R STRIP IAW AMM.SDR SWAA2019040431346Sign · detachedL/H OVERWING EMERGENCY EXIT SIGN FELL OFF. / REINSTALLED SIGN PER MM.SDR HNAA2019040400089Bulb · inoperativeDIS 604 33-51 0024070 03APR19 SBY CLOSE
R/H OVER WING EMERGENCY EXIT LIGHT IS INOP.
27617 00 SPE
FACT 03APR19 10:09 SBY
R & R R/H OVERWING EMERGENCY EXIT LIGHT BULB IAW
SDR MASA2019040311792Battery Pack · dischargedALL EMER EXIT LIGHTS INOP
CHARGED BATTERIESSDR MASA2019040311790Bulb · inoperativePAX DOOR EMERGENCY EXIT SIGN 1 BULB INOP. PLACED ON MELSDR DALA2019040302117Battery Pack · inoperativeFWD OVERWING EXIT LIGHT ABOVE LT TRT OVERWING EXITS INOP. REPLACED BATTERIES FOR THE FWD OVER EXIT SIGNS PER MD88 AMM 35-53. CKS GOOD. (LP5797649)SDR VNAA2019040211102Inverter · failedRH BLUE EMERGENCY EXIT LIGHT INOP BY OVER WING EMERGENCY EXIT INOP. R/R OF INVERTER. IAW CRJ 200 AMM 33-51-07-000/400-801. OPS CHECK GOODSDR YENA2019040520174Power Supply · failedFT # 2824, 1C AND 5C SEAT MOUNTED CLEAR LENS EMERGENCY LIGHTS INOP ( FLOOR PROX EMERG ESCAPE PATH MARK SYS - INCANDESCENT LIGHTING SYS - NOT APPLICABLE TO (N703 AND UP) ); REPLACED EPSU FIN# 10EL PER AMM 33-51-38. PERFORMED EMER LIGHTS SYS TEST PER JETBLUE JOSDR DALA2019040702274Light · damagedSEAT 21D EMERGENCY FLOOR LIGHTING DAMAGED, RE-SECURED EMERGENCY FLOOR LIGHT MOUNT AT SEAT 21DSDR DALA2019040752270Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED ON SERVICE CHECK, REPLACED FWD L EPSU W/ BATTERY.SDR CALA2019040500529Battery · dischargedEMER LIGHT SYSTEM OPERATIONAL TEST FOUND L3 DR M33405 POSITION BATTERY CAN NOT CHARGE. REPLACED THE M33405 BATTERY AT L3 DR POSITION AND EMER LIGHT SYSTEM TEST FOUND NORMAL IAW AMM 33-51-06-200-801 REV.85.SDR CALA2019040500528Charger · inoperativeEMER LIGHT SYSTEM TEST FOUND R2 M33098 BATTERY CHARGER. REPLACED THE R2 DR M33908 BATTERY CHARGER AND EMER LIGHT SYSTEM OPERATION TEST FOUND NORMAL IAW AMM 33-51-06-960-803 REV.85.SDR CALA2019040500527Battery · dischargedEMER LIGHT CAPACITY TEST FOUND EMER LIGHT BATTERY (M33098) AT R2 AND L3 DOORS CAPACITY LOW. REPLACED THE M33098 BATTERY. EMER LIGHT SYSTEM CAPACITY TEST FOUND NORMAL IAW AMM 33-51-06-200-801 REV.85.SDR CALA2019040500526Battery · dischargedEMER LIGHT TEST FOUND M33406 BATTERY CAN NOT CHANGE. REPLACED THE M33406 BATTERY AT L3 DOOR. EMER LIGHT SYSTEM OPERATION TEST FOUND NORMAL REF AMM 33- 51-06-960-803 REV.85.SDR SWAA2019040531393Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR QXEA2019040400153Lamp · inoperativeFORWARD FA JUMPSEAT EMERGENCY LIGHT SWITCH NOT ILLUMINATED. REMOVED FROM SERVICE. RELAMPED FWD FA EMERGENCY LIGHT SWITCH. ALL LAMPS ILLUMINATE. EMERGENCY LIGHTS NORMAL. RETURNED TO SERVICE.SDR DALA2019040432192Lens · damagedEMERGENCY LIGHTS COVER AT 16AB DAMAGED. REPLACED DAMAGED SEAT SHROUD BUMPER. SYSTEM OPERATION IS NORMAL.SDR DALA2019040432189Battery Pack · inoperativeOVER WING EGRESS LIGHTS ARE INOPERATIVE. REPLACED M731 BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SWAA2019040431352Battery Pack · no testAFT L/H EMERGENCY BATTERY SUPPLY AT POSITION #1673 FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM AND DWG.SDR DALA2019040432171Light · cracked(LOG 1013164) DURING INSPECTION FOUND CRACK EMERGENCY LIGHT ASSY LOCATED ON GALLEY 1 AND GALLEY 4 AT PASSENGER CABIN. REPLACED EMERGENCY LIGHT ASSY LOCATED ON GALLEY 1 AND GALLEY 4 AT PASSENGER CABIN AS PER B737-800 AMM-31-51-01.SDR ASAA201904038869Lamp · inoperativeR1 DOOR EXIT SIGN COVER DAMAGED AND BULBS INOP. GROUNDED - YES. REPLACED COVER AND RELAMPED. OPS CHECK GOOD IAW B737-900 AMM 33-51-01.SDR DALA2019040302148Light · inoperativeEPSU SYSTEM TEST FAULT 335116, EXIT SIGNS/EPSU (15WL) DOOR 3. REPLACED CEILING EMERGENCY LIGHT AT SEAT ROW 22AB. LP5674456SDR AALA201904039007Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 DOOR EXTERNAL SLIDE LIGHT WAS INOPERABLE. MAINTENANCE RELAMPED R1 DOOR EXTERNAL SLIDE LIGHT PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019040331319Light · inoperativeLT FORWARD EMERGENCY EXTERNAL LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019040331317Light · malfunctionedROW 15 OVERWING EXIT ROW LIGHT FLUTTERED. R&R LIGHT IAW AMM.SDR FDEA201904020753Warning Message · false activationEMERGENCY LIGHT BAT 1 LO ALERT DURING PRE-FLIGHT. T/S PER MD11 FIM 33-52-00-01. ALL TESTS PASS. NO HISTORY FOR OVER 30 DAYS. PERFORMED ADJ/TEST PER MD11 AMM 33-50-00-5. OPS CK GOOD.SDR 2019F00139Battery Pack · dischargedMULTIPLE EMERGENCY EXIT LIGHTS INOP ON THE RIGHT OVERWING EXIT BATTERY CIRCUIT.SDR REXA2019040200341Charger · inoperativeLH FWD OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED #2, PS2LF EMERGENCY BETTERY CHARGER ASSEMBLY. IAW CRJ AMM 33-51-05 OPS CHECKS GOOD AT THIS TIME.SDR DALA20190402086Battery Pack · inoperativeBOTH AFT OVERWING EMERG EXIT SIGNS INOP DURING EMERG LIGHT CHECK. REPLACED EMERG LIGHT BATTERY IAW MD90 AMM 33-51-03. OPS NORMAL. (LP# 4748966)SDR CA190403019Switch · shorted(CAN) CABIN EMERGENCY LIGHT LATCHED ON - EMERGENCY LIGHT INOP IF IT`S THE BATTERY THAT`S DEFECTIVE, CHECKED POWER SUPPLY, RELAY AND SWITCH. THE SWITCH WAS A SHORT CCT CAUSING THE BATTERY TO DIE. THE OTHERS ARE WORKING BUT I WAS PLANNING TO ORDER THEM CRITSDR VNAA2019040111101Battery Pack · failedEMERGENCY BATTERY WILL NOT STAY ON. REMOVED AND REPLACED 4 BATTERY PACKS IAW CRJ 200 AMM 33-51-04-000/400-801 OPS CK GOOD. #1 P/N AD2013-1A S/N 69914, #2 S/N 122491, #3 S/N 89779, #4 S/N 187402SDR SWAA2019042431972Charger · inoperativeAFT CABIN, EMERGENCY EXIT LIGHTS COMMON TO M1673 BATTERY PACK ARE INOP. / REMOVED AFT LEFT EMERGENCY LIGHT BATTERY CHARGERSDR AALA201904049010Light · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS THE EMERGENCY AISLE LIGHT INOP AT SEATS 21 A,B,C. REMOVED AND REPLACED EMERGENCY AISLE LIGHT AT SEAT 21 A, B, C. OPS CHECK GOOD IAW AMM 33-51-00.SDR DALA2019040422159Fuse · inoperativeEMERGENCY LIGHTS INOP ON FIRST 3 ROWS RT SIDE. REPLACED FUSE IN BATTERY POWER PACK. LIGHTS CK GOOD.SDR DALA2019040312136Power Supply · inoperativeASPSU WILL NOT TEST AFTER BATTERY REPLACEMENT. REPLACED POWER SUPPLY. LP 5268388SDR AALA201904039006Light · faultyAIRCRAFT WAS NOT GROUNDED: SEAT 18D EMERGENCY EXIT LIGHT ON CONTINUOUSLY. MAINTENANCE REPLACED SEAT MOUNTED LIGHT ASSEMBLY PER AMM 33-60-98.SDR AALA201904032005Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY PACK FAILED WORK CARD 2908. REPLACED BATTERY PACK PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904032001Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS FROM 9D THROUGH 15DEF WERE VERY DIM. MAINTENANCE REPLACED CHARGER AND BATTERY PACK M10952 PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019040331318Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2019040331312Lens · looseAISLE EMERGENCY LIGHT LENS LOOSE BETWEEN ROWS 14 TO ROW 15 ON CEILING PANEL. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019040331296Light · inoperativeEMERGENCY CEILING AREA LIGHT INOP AT ROW 1. RELAMPED LIGHT IAW AMM.SDR AALA2019040329016Charger · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND THE SEAT MOUNTED EMERGENCY LIGHTS FROM 1E THRU 4E INOP. REPLACED BATTERY PACK AND CHARGER M10798 IAW AMM 33-51-07. SEAT MOUNDED LIGHTS OPS CHECK GOOD.SDR IPXA2019040314689Lamp · inoperativeEMERGENCY EXIT LIGHT ON RT SIDE OF FUSELAGE LOWER INOP.RELAMPED LIGHT ASSY OPS CKS NORMALSDR SWAA2019040231285Sign · damagedCENTER OVERHEAD EMERGENCY LIGHT SIGN DAMAGED. R&R SIGN IAW AMM.
Back to JASC 3350