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 AALA201708149004Lens · missingEXIT SIGN LENS MISSING AFT LEFT BY LAVATORY L73. REPLACED THE LENS.SDR AALA201708149003Battery · failedEMERGENCY POWER SUPPLY UNIT BATTERY FAILED AT 16WL. REPLACED BATTERY AT 16WL.SDR AALA201708149001Light · inoperativeFLIGHT DECK EMERGENCY LIGHT NOT WORKING. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR AALA20170812002Connector · looseEMERGENCY LIGHT AT SEAT 34D IS INOPERATIVE. RESEATED CONNECTOR AT THE WALL. OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA20170812001Battery Pack · no testAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS IN THE FIRST CLASS ARE DIM. REMOVED AND REPLACED BATTERY PACK AND CHARGING MODULE (AALA201708149010) AT M10798 PER AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170811005Light · brokenEMERGENCY EXIT DIRECTIONAL FLOOD LIGHT AT THE RIGHT FORWARD GALLEY FLOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR REXA2017081100876Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT THE PAX DOOR EXTERIOR, GALLEY OVERHEAD, GALLEY WINDSCREEN, & OVERHEAD FACING FIRST CLASS FROM ROW 5. R & R THE BATTERY PS35. OPS CHECKED GOOD.SDR IPXA2017081420473Sign · detachedEXIT SIGN AT THE RT DOOR, FELL OFF DURING TAKE OFF. REPLACED THE SIGN ASSY IAW AMM 33-27-05. OPS TESTED GOOD.SDR DALA2017081406224Lens · unsecureEMERGENCY EXIT SIGN COVER LOOSE. LOCATED AND REINSTALLED EXIT SIGN LENS AT OVER WING EXIT.SDR DALA2017081406170Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REPAIRED THE LENS. OK FOR SERVICE.SDR MASA2017081112527Light · inoperativeO/H EMER LIGHT ROW 6 OUT. MX TROUBLESHOOTING.SDR 29GA2017081300001Bulb · burned outCABIN EMERGENCY EXIT LIGHT SWITCH BULB BURNED OUT. REMOVED AND REPLACED CABIN EMERGENCY EXIT SWITCH LIGHT BULB IAW SAAB 340 AMM 33-500-00. OPS CHECKED GOOD.SDR CALA2017081102627Light · looseEMERGENCY EXIT LIGHT LOOSE ON FWD LEFT BULKHEAD. REPLACED EMERGENCY LIGHT, CHECKED GOOD.SDR CALA2017081102626Power Supply · no testEMERGENCY LIGHT TEST FAILED ON 2 SERVICE CHECK. REPLACED THE ESPU AND BATTERY, OP CHECKED NORMAL.SDR CALA2017081102625Lens · missingEMERGENCY LIGHT COVER ON FIRST CLASS BULKHEAD MISSING. INSTALLED A NEW LENS. OPS CHECKED GOOD.SDR CALA2017081102624Lens · missingEMERGENCY LIGHT CLEAR LENS MISSING. LIGHT OPS OK. REPLACED THE LENS. OPS NORMALSDR CALA2017081102623Cover · missingEMERGENCY LIGHT COVER MISSING AT 1B. LIGHT DOES ILLUMINATE. REPLACED EMERGENCY LIGHT COVERSDR CALA2017081102621Lens · detachedEMERGENCY EXIT SIGN LENS BY SEAT 25 FELL OFF. SECURED THE LENS.SDR CALA2017081102620Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, RT SIDE AFT OF OVERWING EXITS. REPLACED THE BATTERY PACK AT POWER SUPPLY M1671. ALL EMERGENCY LIGHTS OPERATE NORMAL, INTERIOR AND EXTERIOR.SDR CALA2017081102618Lens · detachedEMERGENCY LIGHT LENS AT EXIT ROW AISLE FELL OFF. REINSTALLED THE LIGHT LENS.SDR CALA2017081102617Battery Pack · no testEMERGENCY BATTERY PACK M1669 DOES NOT PASS THE CAPACITY CHECK. REPLACED THE RIGHT OVERWING BATTERY PACK IAW AMM 33- 51-06, TESTED FOUND NORMAL.SDR CALA2017081102615Lamp · inoperativeR2 DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-06.SDR CALA2017081102614Lamp · inoperativeRIGHT AFT SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06, OPS CHECKED GOOD.SDR CALA2017081102613Light · inoperativeEMERGENCY EXIT LIGHT OVER COCKPIT DOOR IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT.SDR CALA2017081102612Receptacle · dirtyEMERGENCY EXIT GROUND LIGHT, RT SIDE AFT OF WING IS INOPERATIVE. CLEANED THE RECEPTICLE, OPS CHECKED GOOD.SDR CALA2017081102611Receptacle · dirtyEMERGENCY EXIT GROUND LIGHT, LEFT SIDE, AFT OF WING IS INOPERATIVE. CLEANED RECEPTICLE, OPS CHECKED GOODSDR CALA2017081102610Lamp · inoperativeRIGHT SIDE EXTERNAL EMERGENCY LIGHT JUST FORWARD OF AFT CARGO DOOR IS INOPERATIVE. REPLACED THE LAMP, OPS CHECKED OK.SDR CALA2017081102608Light · detachedEMERGENCY LIGHT NEAR LAVATORY 101, FALLING OFF WALL INSTALLED AND FUNCTIONAL CHECKED OKSDR ASOA201708112001Battery Pack · inoperativeWHEN TESTING THE EMERGENCY LIGHTING SYSTEM; FOUND EXTERIOR EMERGENCY LIGHTS NR 1 AND 2 AND CABIN CEILING EMERGENCY FLOOD LIGHT NR 1 INOPERATIVE. REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT BATTERY PACK AND DETERMINED PROPER OPERATION.SDR FDEA201708112187Lamp · inoperativeR1 DOOR EMERGENCY SLIDE LIGHT FOUND INOPERATIVE DURING TEST. REPLACED THE LAMP AND OPS CHECKED NORMAL IAW MM 33-51-06-2-1. ACFT OK FOR SERVICE.SDR A6WA201745192Inverter · inoperativeEMERGENCY FLOOR TRACK LIGHTS BETWEEN ROWS 5 & 8 PLUS RIGHT FLOOR LEVEL EXIT SIGN DID NOT ILLUMINATE. INSPECTED EMERGENCY FLOOR TRACK LIGHTING BOTTOM TRACK COVER FOUND TO BE SECURE TO FLOOR AND COVER ATTACHED AND IN GOOD CONDITION. FOUND WIRING CONNECTIONS SECUSDR AALA20170814003Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33400 AT THE L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170814002Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33408 AT THE R4 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170814001Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33404 AT THE R3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170813010Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33406 AT THE L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170813009Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33097 AT THE R2 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170813008Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33096 AT THE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2017081615738Cover · missingR1 DOOR EMERGENCY LIGHT COVER MISSING. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017081615730Lens · missingR2 DOOR EMERGENCY EXIT LIGHT COVER LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017081615723Light · dimLT OVERWING EMERGENCY EXIT LIGHT IN FRONT OF EXIT HATCH DIM. RELAMPED LIGHT PER AMM.SDR SWAA2017081515656Battery Pack · dischargedR1 DOOR OUTSIDE EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017081415647Lens · crazedRT EMERGENCY EXIT LIGHT LENS CRAZED AT ROW 8. R&R LENS PER AMM.SDR HALA2017081100216Cover · missingEMERGENCY LIGHT SIGN ABOVE SEAT 16H MISSING IT'S COVER. REPLACED EMERGENCY LIGHT AT SEAT 16H.SDR AALA201708149047Light · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. MID GALLEY LOWER SIDEWALL EMERGENCY LIGHT INOP. REPLACED LIGHT ASSY AT LOWER MID GALLEY LOWER SIDEWALL PER AMM 33-51-05 AND AMM 20-30-12, OPS CKS NORMAL.SDR AALA201708149045Lens · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE LIGHT LENS ON ROWS 19CBA, 21FED 25FED ARE DAMAGED. 25FED WERE REPLACED IAW AMM 33-51-03 GOOD FOR SERVICE.SDR AALA201708149044Lens · unsecureTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY PATH LITE LENS JUST AFT OF IST CLASS GALLEY ON AISLE WILL NOT STAY ON. REPLACED EMERGENCY LIGHT LENS JUST AFT OF 1ST CLASS GALLEY OPS CKS OK PER MM 35-51-00.SDR AALA201708119022Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN IS MISSING AT 1R. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER AMM 33-51-01 CKS OK AT 1R DOOR.SDR AALA20170811003Light · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. THE MID GALLEY LOWER SIDEWALL EMERGENCY LIGHT INOP. REPLACED LIGHT ASSY AT LOWER MID GALLEY LOWER SIDEWALL PER AMM 33-51-05 AND AMM 20-31-12, OPS CKS GOOD.SDR AALA201708119026Light · brokenEMERGENCY EXIT LIGHT FIXTURE BROKEN AT L4 DOOR. REPLACED THE LIGHT FIXTURE IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017081415648Lens · crazedR/H EMERGENCY EXIT LIGHT LENS CRAZED AT ROW 6. R & R LENS IAW AMM.
Back to JASC 3350