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 AALA20160927006Power Supply · faultySEVERAL EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AT L2 DOOR IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR SWAA2016092808232Battery Pack · no testFORWARD CABIN LEFT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW MM.SDR SWAA2016092808231Battery Pack · no testAFT CABIN RT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW MM.SDR SWAA2016092808230Battery Pack · no testAFT CABIN LEFT BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR AALA201609289027Battery Pack · no testEMERGENCY POWER SUPPLY UNIT 11WL BATTERY FAILED CAPACITY CHECK. REPLACED THE BATTERY PACK IAW AMM 33-31-38-401.SDR AALA201609289026Battery · no testEMERGENCY POWER SUPPLY UNIT 12WL BATTERY FAILED CAPACITY CHECK. REPLACED BATTERY IAW AMM 33-31-38-401.SDR AALA201609289025Battery · no testEMERGENCY POWER SUPPLY UNIT 13WL BATTERY FAILED CAPACITY CHECK. REPLACED BATTERY PER AMM 33-31-38-401.SDR AALA201609289024Battery · no testEMERGENCY POWER SUPPLY UNIT 14WL BATTERY FAILED CAPACITY CHECK. REPLACED BATTERY IAW AMM 33-31-38-401.SDR AALA201609289023Battery · no testEMERGENCY POWER SUPPLY UNIT 16WL BATTERY FAILED CAPACITY CHECK. REPLACED BATTERY IAW AMM 33-31-38-401.SDR AALA201609289022Battery · no testEMERGENCY POWER SUPPLY UNIT 18WL BATTERY FAILED CAPACITY CHECK. REPLACED THE BATTERY IAW AMM 33-31-38-401.SDR AALA201609289003Lens · missingSEAT 10 ABC EMERGENCY MOUNTED LIGHT MISSING LENS. INSTALLED MISSING LENS IAW AMM 33-20-00.SDR A6WA201644383Light · inoperativeFIRST 2 ROWS OF FLOOR EMERGENCY LIGHTING TRACK WILL NOT STAY SECURE, FIRST ORANGE LIGHT SECTION INOPERATIVE.SDR AALA20160927003Power Supply · faultyFIRST CLASS EMERGENCY LIGHT AND EXIT SIGNS AT L1 & R1 DOORS ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33093 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR QXEA2016092700614Light · inoperativeFORWARD F/A EMERGENCY LIGHT BULB IS BURNED OUT. RELAMPED THE FORWARD F/A EMERGENCY LIGHT. OPS TESTS GOOD. RETURNED TO SERVICE.SDR DALA2016092706959Controller · faultyEMER PWR TEST OF LIGHTS FAULTING L2 DOOR. REPLACED EPSU CONTROLLER AT L2 DOOR.SDR VNAA2016092600029Light · detachedLEFT HAND FORWARD EMERGENCY FLOOR PATH MARKING DETACHED FROM FLOOR. MAINTENANCE INSPECTED, RESECURED THE LEFT HAND FORWARD EMERGENCY FLOOR PATH MARKING AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR SWAA2016092808240Cover · detachedFORWARD GALLEY EXIT SIGN COVER NEAR R1 DOOR FELL OFF. INSTALLED COVER IAW SIP.SDR ASAA2016092618135Lens · detachedFA REPORTS EMERGENCY EXIT COVER IN AFT GALLEY RIGHT SIDE FELL OFF. ACFT GROUNDED. REINSTALLED EMERGENCY EXIT COVER IN AFT GALLEY RIGHT HAND SIDE PER B737-800 AMM 33-51-01. LIGHT CHECKED GOOD.SDR SWAA2016092708222Lens · looseL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016092608206Sign · missingRIGHT OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN ASSEMBLY IAW AMM.SDR DALA2016092706899Battery Pack · malfunctionedEXTERIOR EMERGENCY LOWERING LIGHTS INOPERATIVE. RESET BATTERY PACK EMERGENCY LIGHT IAW AMM 33-53. OPERATED EMERGENCY LIGHTS, WORKS NORMAL , OK FOR SERVICES.SDR QXEA2016092700615Light · inoperativeEMERGENCY LIGHT SWITCH NORMAL, LAMP NOT ILLUMINATED. RELAMPED LIGHT, ILLUMINATE PROPERLY. RETURNED TO SERVICE.SDR DALA2016092706849Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN THE VENTRAL STAIRWAY WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR MASA2016092612419Light · inoperativePAX CABIN DOOR EMERGENCY LIGHT LIGHT INOPERATIVE. OPENSDR MASA2016092612417Bulb · inoperativeCEILING PANEL ROW 17/20 EMERGENCY EXIT LIGHTS INOPERATIVE. MX REPLACED THE LAMPS.SDR CALA2016092600692Battery · inoperativeCABIN EMERGENCY EXIT LIGHTS ON SEATS AT O/W EXIT DOOR INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY IAW MM 33-51-06-960-805, EMERGENCY LIGHTS OPS NORMAL.SDR CALA2016092600691Battery Pack · inoperativeLEFT FWD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51-06-960-805, OPS NORMAL.SDR CALA2016092600690Lamp · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-51-06.SDR CALA2016092600689Lamp · inoperativeLEFT MID OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-06.SDR HNAA2016092600296Bulb · dimLEFT FORWARD EXTERIOR OVERWING EMERGENCY LIGHT DIMMING OUT. REMOVED AND REPLACED BULB IAW MM 33-50-10-04. OPS CHECKED GOOD.SDR HNAA2016092600294Battery Pack · inoperativeRIGHT AFT OUTSIDE EMERGENCY EXIT EGRESS LIGHT IS INOPERATIVE. LOWERED PSU COVER AT ROW 7DF. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY. SECURED PSU COVER PANEL AT ROW 7DF. OPS CHECKED GOOD.SDR HNAA2016092600293Bulb · inoperativeFLOOR EMERGENCY LIGHT IS OUT AT ROW 3DF. REMOVED AND REPLACED BULB. OPS CHECKED GOOD.SDR SWAA2016101108664Battery Pack · inoperativeR2 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. REINSTALLED THE BATTERY PACK IAW AMM.SDR SWAA2016101108639Battery Pack · inoperativeL2 DOOR EMERGENCY SLIDE EXIT LIGHT INOPERATIVE. REINSTALLED BATTERY PACK IAW AMM.SDR SWAA2016092708215Lens · brokenG1 GALLEY EMERGENCY LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR DALA2016092606907Fuse · inoperativeMULTIPLE EMERGENCY LIGHTS OUT IN 1ST CLASS. REMOVED & REPLACED FUSES ON APPLICABLE POWER SUPPLY. OPS CHECKED GOOD.SDR ASAA2016092518131Lamp · failedL2 EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS, OPS CHECK GOOD IAW AMM 33-51-04-960-801.SDR SWAA2016092608205Cover · missingRIGHT LOWER VERTICAL EXIT SIGN COVER MISSING. INSTALLED COVER IAW AMM.SDR N6WA2016092501Light · inoperativeLEFT EMERGENCY EXIT SIGN BULB INOPERATIVE.SDR CALA2016092600685Battery Pack · dischargedSTOW BIN EMERGENCY LIGHT INOPERATIVE AT ROW 32 DEF. REMOVED & REPLACED THE BATTERY PACK AT BS 727K IAW AMM 33-51-06 FOR ZONE 8. OPS CHECKED GOOD.SDR CALA2016092600684Battery Pack · dischargedEMERGENCY LIGHTS FROM ROW 22-25 ABC INOPERATIVE. REMOVED & REPLACED THE BATTERY PACK.SDR AALA20160926001Power Supply · inoperativeDURING CIDS TEST EPSU (12WL) FILED. REMOVED AND REPLACED EPSU 12WL IAW MM 33-51-38. OPS CHECKED NORMALSDR AALA201609269018Light · brokenEMERGENCY LIGHT MOUNTED ON SEAT 7G BROKEN. AIRCRAFT WAS NOT GROUNDED. REPLACED EMERGENCY LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA201609269006Light · brokenEMERGENCY LIGHT MOUNTED ON SEAT 23B BROKEN. REPLACED EMERGENCY LIGHT AT SEAT 23B AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-00.SDR AALA201609269003Lens · crackedAFT RIGHT WING TO BODY FAIRING UPPER EMERGENCY LIGHT LENS CRACKED. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-50-25.SDR IPXA2016092508610Battery Pack · dischargedEMERGENCY LIGHT TEST BATTERY LOW MESSAGE. R & R THE BATTERY PACK IAW AMM 33-51-01-401-000-802. OPS CHECKED OKSDR DALA2016092606838Battery Pack · dischargedDURING EMERGENCY LIGHTS TEST, FOUND LT AND RT EXTERIOR LIGHTS INOPERATIVE. R & R B5-49 EXT EMERGENCY BATTERY PACK AND BATTERY IAW AMM 33-53. EXTERIOR EMERGENCY LIGHTS. CHECK NORMAL IAW AMM 33-53. ACFT OK FOR SERVICE.SDR A6WA201644369Light · inoperativeCREW REPORTED EMERGENCY FLOOR TRACK LIGHTS NOT WORKING FROM ROWS 5-8.SDR JJBA20160925012Battery · dischargedEMERGENCY LIGHTS ARE NOT WORKING. FOUND EMERGENCY BATTERIES DRAINED. R & R PS1, PS2, PS3, PS4, PS5, AND PS6 EMERGENCY LIGHT BATTERIES. OPS CHECK SATISFACTORY IAW AMM 33-51-00. ADDITIONAL SN`S ARE AS FOLLOWS: 011119, TT 1056.55, TC 1223; 9806111, TT 29247.2SDR MASA2016092512414Light · inoperativeROW 14 AND 20 CEILING EMERG FLOOD LIGHTS INOPERATIVE.
Back to JASC 3350