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 DALA2020033002077Battery Pack · dischargedSHIP 674 EMERGENCY BATTERY POWER SUPPLY AT 27 DEF INOP. CORRECTIVE ACTION: REMOVED & REPL BATT PACK & CHARGER PER B757 AMM 33-51 ALL OPS NML. (6443828)SDR CALA2020032700732Battery Pack · dischargedB737-33-3-0235 - L2 DOOR EXIT INDICATORS INOP UPDATED INFORMATION SDRSDR I5EA2020032707Power Supply · unknownR2 EMERGENCY EXIT LIGHT INOP.SDR IPXA2020032753607Battery · dischargedINSPECTION TYPE:D1FOUND EMERGENCY EXIT SIGN AND SLIDE LIGHT INOP AT R/H U/D DOOR AREA.1.I.A.W. AMM 33-51-04-902-001-001 REV.97.03 REPLACED THE EMERGENCY LIGHT BATTERY ASSEMBLY M5056. 2.I.A.W. AMM 33-51-04-902-001-001 REV.98.00 PERFORMED EMERGENCY LIGHT BATTERYSDR IPXA2020032753606Battery · dischargedINSPECTION TYPE:D1FOUND LEFT SIDE U/D DOOR EMERGENCY LIGHT INOP.1.I.A.W. AMM 33-51-04-902-001-001 REV.97.03 REPLACED THE EMERGENCY LIGHT BATTERY ASSEMBLY M5057. 2.I.A.W. AMM 33-51-04-902-001-001 REV.98.00 PERFORMED EMERGENCY LIGHT BATTERY FUNCTION TEST,RESULT SDR I5EA2020032706Power Supply · unknownL 1 DOOR EMERGENCY LIGHT(EXTERNAL) INOP.SDR SWAA2020032634309Light · inoperativeEMERGENCY LIGHT AT FWD SVC. DOOR INOP / RELAMPED FWD SVC DOOR EMERGENCY LIGHT ASSY. PER AMM 33-51-04SDR F3LA202003260024Epsu · failedDISCREPANCY: LP1241800 ITEM 1: DURING OVERNIGHT MAINTENANCE, EPSU SYS TEST FAILED DUE TO EPSU 11WL FAULT. CORRECTIVE ACTION: REMOVED AND REPLACED EPSU 11WL, DUE TO FAULTING PERFORMED EPSU SYS TEST, TEST PASSED. REF AMM 33-51-38-000-001-A AND AMM 33-51-38-400SDR SIMA2020070225009Strip · tornNR 8 EMERGENCY LIGHT STRIP IS TORN. REMOVED AND REPAIRED THE NR 8 EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR SWAA2020033034229Battery Pack · dischargedSEVERAL FWD CABIN EMERGENCY LIGHTS DO NOT OPERATE. / REMOVED; REPLACED; AND PERFORMED GOOD OPS CHECK OF EMERGENCY LIGHTS BATTERY PACK M1674 PER AMM 33-51-06-960-805. ALL EMERGENCY LIGHTS OPERATE CORRECTLY.SDR SWAA2020033034246Battery · failedCABIN EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675 / REMOVED AND REPLACED CABIN EMERGENCY LIGHT BATTERY AT LOCATION M01675 PER AMM 33-51-06SDR SWAA2020033034106Light · inoperativeLT SLIDE/OVERWING EMERGENCY LIGHT INOP. / RELAMPED LT SLIDE/OVERWING EMERGENCY LIGHT; OP'S CHECK GOOD. REF AMM 33-51-04SDR SWAA2020033034747Light · inoperativePASSENGER CABIN L/H EMERGENCY EXIT OVERWING DOOR SIDEWALL LIGHT INOP. / RELAMPED PASSENGER CABIN L/H EMERGENCY EXIT OVERWING DOOR SIDEWALL LIGHT IAW AMM 33-51-04SDR DALA2020033002082Power Supply · corroded(AIRCRAFT 3123, L/P 1539547) CORROSION CONNECTOR CHANNEL B LOC. ON POWER SUPPLY UNIT (18VL) IN THS COMPARTMENT. CORRECTIVE ACTION: REPLACED POWER SUPPLY UNIT (18VL) IN THS COMPARTMENT AS PER A319 A320 FAM AMM 33-48-39-400-001-A.SDR DALA2020032702056Battery Pack · discharged(LOG 7008966) LEFT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED LEFT OVERWING EXIT LIGHT BATTERY PACK PER B737 AMM 33-51. OPS CHECK GOOD.SDR AALA2020032769005Lens · brokenAIRCRAFT WAS NOT GROUNDED: LEFT EMERGENCY LIGHT LENS BROKEN ON SEAT. MAINTENANCE REPLACED LIGHT PER AMM 33-51-19.SDR AALA2020032759002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BITE TEST FAILED. MAINTENANCE FOUND EMERGENCY POWER SUPPLY UNIT FAULTY AND REPLACED POWER SUPPLY UNIT PER AMM 33-51-58-0401.SDR SWAA2020032634201Light · looseEXIT SIGN HANGING OFF CEILING / R&R LIGHT ASSY ; RESECURED AND OPS CHECK PER M/M 33-51-04 & 33-51-00SDR MASA2020032500138Cover · out of position13F FLR LVL EMER EXIT SIGN ONE BULB INOP REPOSITIONED COVERSDR MASA2020032500137Light · inoperativeGALLEY FLR LVL EMER SIGN ONE BULB INOP. RELAMPED.SDR QXEA2020032500144Light · looseEMERGENCY LIGHT STRIP IN FRONT OF THE FORWARD GALLEY SLIDES OUT OF TRIM. REMOVED FROM SERVICE. R & R EMERGENCY FLOOR PATH LIGHT PANEL IN FWD GALLEY IAW Q400 AMM 33-51-16-000/400-801. OPC GOOD.SDR MASA2020032500136Light · inoperative14A FLR LVL EXIT SIGN ONE BULB INOP. RELAMPEDSDR MASA2020032500135Light · inoperativeLH FWD FLR LVL EXIT SIGN ONE BULB INOP. PLACED ON MELSDR DALA2020032502032Battery Pack · dischargedTHE EMERGENCY EXIT LIGHTS AT THE AFT OVERWING EXIT (ROW 25) ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK ABOVE ROW 25DE PER MD-88 AMM 33-53. OPERATIONAL CHECK WAS GOOD. (LP #7018955)SDR SWAA2020033033954Battery Pack · dischargedEMERGENCY LIGHT INOP AT 3;6D. / R&R FWD BATTERY PACK AND OPS CHECKED GOOD REF MM 33-51-06SDR SWAA2020033033531Cradle · inoperativeEMERGENCY OVERWING GROUND ILLUMINATION LTS. INOP. / R & R M1670 BATTERY PACK CRADLE ASSY. PER MM 33-51-06.SDR DALA2020032702057Light · broken(LOG 1538807) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REMOVED AND REPLACED BROKEN L2 EMERGENCY EXIT LIGHT ASSY WITH NEW PER B737 AMM 33-51. OPS CHECK GOOD.SDR CALA2020032700730Lens · missingGALLEY #9 COMPT #913 & #916 EMERGENCY PATH LIGHT LENS MISSING. INSTALLED GALLEY #9 COMPT #913 & #916 EMERGENCY PATH LIGHT LENS PER AMM 33-51-10SDR AALA202003269003Battery · dischargedAIRCRAFT WAS NOT GROUNDED: AFT LEFT FLIGHT ATTENDANT FLASHLIGHT FLASHED RED DURING TEST. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR SIMA202003254002Light · inoperativeROW 12 OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED ROW 12 OVERWING EMERGENCY LIGHT IAW AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A. OPC GOOD. END.SDR SIMA202003254001Light · inoperativeRIGHT HAND OVERWING EXIT LIGHT INOP-C/A-REMOVED AND REPLACED LAMP FOR THE RH OVERWING EMERGENCY EXIT LIGHT IAW AMM 33-50-07. OPS CHECK GOODSDR SWAA2020032633698Battery Pack · dischargedAFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP / R&R M1672 BATTERY PACK PER W.D.M. 33-51-14 & A.M.M. 33-51-00.SDR AALA2020032649010Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT EMERGENCY LIGHT IN THE SIDEWALL LIGHT ENCLOSURE INOPERATIVE AT 14DEF. MAINTENANCE RELAMPED LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA2020032649003Battery · failedAIRCRAFT NOT GROUNDED - R2 DOOR FAILS EMERGENCY POWER SUPPY UNIT (EPSU) TEST.REMOVED AND REPLACED BATTERY AT R2 DOOR EPSU (14WL) PER AMM 33-51-38-400-002. OPERATIONAL CHECK GOOD.SDR ASAA2020032532530Battery Pack · failedR1 DOOR EMERGENCY LIGHTS INOP. GROUNDED - YES. REMOVED AND REPLACED R1 DOOR EMERGENCY LIGHT BATTERY PACK, OPS CHECK GOOD. IAW B737-900 AMM 33-51-06-960-805.SDR YENA2020032430265Battery · failedFLT # 190. SAN-JFK. EPSU BATT AT LOCATION 13WL 14WL 15WL FAILED EMEGENCY LIGHT TEST ; R & R EPSU BATT AT LOCATION 13WL 14WL AN 15WL IAW AMM 33-51-38- OPS CHECK GOODSDR YENA2020032430264Battery · failedFLT # 190. SAN-JFK. EPSU BATT AT LOCATION 13WL 14WL 15WL FAILED EMEGENCY LIGHT TEST ; R & R EPSU BATT AT LOCATION 13WL 14WL AN 15WL IAW AMM 33-51-38- OPS CHECK GOODSDR YENA2020032430262Battery · failedFLT # 190. SAN-JFK. EPSU BATT AT LOCATION 13WL 14WL 15WL FAILED EMEGENCY LIGHT TEST ; R & R EPSU BATT AT LOCATION 13WL 14WL AN 15WL IAW AMM 33-51-38- OPS CHECK GOODSDR YENA2020032430263Battery · failedFLT # 190. SAN-JFK. EPSU BATT AT LOCATION 13WL 14WL 15WL FAILED EMEGENCY LIGHT TEST ; R & R EPSU BATT AT LOCATION 13WL 14WL AN 15WL IAW AMM 33-51-38- OPS CHECK GOODSDR YENA2020032430260Epsu · failedFLT #190. SSN-JFK. EPSU AT LOCATION 12WL FAILED EMERGENCY TEST ; R & R EPSU AT LOCATION 12WL IAW AMM 33-51-38. OPS CHECK GOODSDR MASA2020032300133Light · inoperativeROW 12AC LWR LEVEL EMR LT 2 BULBS INOP. RELAMPED.SDR MASA2020032300132Light · inoperativeFLOOR LVL EXIT LIGHT BULB OUT AT 14DF. PLACED ON MELSDR SWAA2020033033511Light · inoperativeONE LAMP AT FORWARD ENTRY EMERGENCY EXIT INDICATOR AND ONE BULB AT AFT CEILING LEFT INDICATOR DO NOT ILLUMINATE. / RELAMPED FORWARD ENTRY EMERGENCY EXIT INDICATOR AND AFT CEILING LEFT INDICATOR AND PERFORMED GOOD TEST OF NEW LAMPS PER AMM 33-51-01-960-801 9312SDR SWAA2020032634133Battery Pack · dischargedEXTERIOR EMERGENCY LIGHT AFT OF THE AFT SERVICE DOOR IS INOP / REMOVED & REPLACED EMERGENCY BATTERY POWER SUPPLY M1672 AND EMERGENCY BATTERY PACK M1672 I.A.W. AMM 33-51-06. EMERGENCY LIGHT OPERATIONAL TEST GOOD.SDR SWAA2020032633202Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE AFT SERVICE DOOR IS INOP / REMOVED & REPLACED EMERGENCY BATTERY POWER SUPPLY M1672 AND EMERGENCY BATTERY PACK M1672 I.A.W. AMM 33-51-06. EMERGENCY LIGHT OPERATIONAL TEST GOOD.SDR AALA2020032549004Battery · faultyAIRCRAFT NOT GROUNDED - EMERGENCY POWER SUPPY UNIT (EPSU) TEST FAULTED BATTERY 15WL. REPLACED POSITION 15WL BATTERY, PERFORMED RETEST AND OPERATIONAL CHECK GOOD PER AMM 33-51-38.SDR AALA2020032539008Control Unit · faultyAIRCRAFT WAS GROUNDED: PERFORMED FIM TASK 33-50-F-P2A-421A-A. FOUND 6 WCUS INACTIVE. WCUS REQUIRE KEY TRANSFER IAW AMM 33-51-07-06-950A-A. SWAPPED WCU 1 AND 13. THAT CLEARED FAULTS AT 30 AND 17. REPLACED WCU AT 9.2, 21,13 AND 23. LOADED SOFTWARE. SYSTEM OPS SDR SWAA2020032442707Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE AFT SERVICE DOOR IS INOP REMOVED & REPLACED EMERGENCY BATTERY POWER SUPPLY M1672 AND EMERGENCY BATTERY PACK M1672 I.A.W. AMM 33-51-06. EMERGENCY LIGHT OPERATIONAL TEST GOOD.SDR DALA2020032402030Power Supply · inoperative(LOG 6968426) ON SVC CHECK. FOUND FWD LWR OVERWING EXIT LIGHT OUT. R/R BATTERY CHARGER PWR SUPPLY AT LOCATION STA 576 L/H PER B737 AMM 33-55. OPS CHECK NORMAL.SDR AALA202003249008Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT FORWARD EXTERIOR LIGHT INOPERABLE. MAINTENANCE RELAMPED LIGHT PER AMM 33-51-04.
Back to JASC 3350