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 CALA2017090102988Charger · faultyEMERGENCY ISLE LIGHTING ON SEATS 1K, 2K, 3C,3H, 3K, 4C, 4K, 4H DO NOT ILLUMINATE. REPLACED BATTERY CHARGER ABOVE DOOR 1R. REF AMM33-51-04-902-001 -002. OPS CHK''D GOOD. REF AMM31-51-04-712-007-002.SDR CALA2017090102986Power Supply · faultyEMERGENCY AISLE LIGHTS ON SEATS 45H THRU 51H ARE VERY DIM. REPLACED POWER SUPPLY M6010 ABOVE DR 4 RT REF AMM 33-51-04-902-0 01-002. OPS CHECKED GOOD REF AMM 33-51-04-712-007-002.SDR CALA2017090102985Lamp · inoperativeEMERGENCY LIGHT ABOVE L4 DOOR DOES NOT ILLUMINATE. REPLACED THE LAMP AND TESTED GOOD IAW AMM 33-51-07.SDR CALA2017090102983Light · detachedEMERGENCY LIGHT ON SEAT 19C IS HANGING BY ITS WIRES. ATTACHED THE EMERGENCY LIGHT. LIGHT IS SECURE AND OPS CHECKED GOOD.SDR CALA2017090103018Circuit Breaker · malfunctionedEMERGENCY EXIT LIGHTS WILL NOT SHUT OFF. CYCLED CIDS CIRCUIT BREAKER. CHECKED OKSDR CALA2017090103014Lens · missingEMERGENCY LIGHT LENS COVER IS MISSING AT SEAT 1B. REPLACED THE COVER, OPS OKSDR CALA2017090102999Lens · detachedCABIN AISLE EMERGENCY EXIT SIGN COVER BY BULKHEAD FELL OFF. INSTALLED LENSSDR CALA2017090102997Lamp · inoperativeL3 DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP IAW AMM 33-51-06.SDR CALA2017090102995Lamp · inoperativeL3 DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-06.SDR CALA2017090102987Lamp · inoperativeOVERHEAD EMERGENCY LIGHT AT NR 2 MED INOPERATIVE. REPLACED THE LAMP AND TESTED GOOD REF. AMM 33-51-06.SDR CALA2017090102955Lens · brokenEMERGENCY EXIT COVER 18F BROKEN. REMOVED & REPLACED LIGHT LENS IAW AMM 33-51-01.SDR DALA2017090106520Battery Pack · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE OVER THE FWD OVERWING EXIT DOOR. REPLACED THE BATTERY PACK. CHECKED NORMAL. REPLACED IAW WDM 33-51-12. OK FOR SERVICE.SDR DALA2017090106513Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND EMERGENCY LIGHTS IN AFT EQUIP BAY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY B5-260 IAW AMM 33-51, OPERATIONAL CHECKED GOOD. AIRCRAFT IS OK FOR SERVICE.SDR DALA2017090106506Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP OVER THE OVER WING EXIT DOOR, AFT DOORS. DURING T/S FOUND EMERGENCY LIGHT BATTERY PACK B5-105 IN POOR CONDITION. RPLD PER WDM 33-51-12. OPS CK NML. OK FOR SVC.SDR SWAA2017090816200Fuse · inoperativeAFT LT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2017090616142Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2017090616106Light · inoperativeRT OVERWING EMERGENCY EXIT WINDOW LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017090616094Lens · brokenFORWARD GALLEY "EXIT LIGHT" LENS COVER BROKEN. R&R LENS IAW AMM.SDR AALA201709059004Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EPSU SYSTEM TEST FAILS 13WL BATTERY PACK WHEN TESTING CIDS 1 SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR RAIA201708310002Bulb · inoperativeLEFT AFT EMERGENCY EXIT DOOR LIGHT NR 23 INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201708310001Bulb · inoperativeLT AFT WING TO FUSELAGE FAIRING EXTERIOR EMERGENCY LIGHT NR 5 IS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR AALA201709059032Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. R-1 FWD GALLEY EMERGENCY LIGHT INOP, BASE IS BROKEN AND LENS IS MISSING. LENS WAS GLUED TO WALL. REPLACED R1 EMERGENCY LIGHT ASSY PER AMM 33-51-01 OPS CKS GOOD.SDR AALA201709059031Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. R4 RIGHT AFT EMERGENCY LIGHT INOP, BASE IS BROKEN AND LANES IS MISSING. LENS WAS GLUED TO WALL. REPLACED R4 EMERGENCY LIGHT ASSY PER AMM 33-51-01, OPS CKS GOOD.SDR HALA2017090100006Sign · detachedEXIT SIGN AT DOOR 3R DETACHED FROM THE DOOR. RE-SECURED EXIT SIGN COVER.SDR HALA2017090100003Light · unsecureFLOORING LIGHTNING LIFTING OFF THE FLOOR AT ROWS 28 AND 29AB. RE-SECURED FLOOR LIGHTING AT ROW 28 AND 29 / AB.SDR AALA201709059022Power Supply · no testEMERGENCY POWER SUPPLY UNIT FAILED, TEST TRIGGERED FAULT. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR REXA2017083100957Light · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE FROM SEATS 1C - 5C, ALL OTHER EMERGENCY LIGHTS BOTH INTERNAL AND EXTERNAL WORK. INSPECTED EMERGENCY LIGHT STRIP IAW AMM 33-51-01. CLEANED CONNECTORS, GREEN LIGHTS ILLUMINATED. UNABLE TO GET MOST FWD SECTION OF AMBER LIGHTSSDR DALA2017090200002Sign · brokenEMERGENCY EXIT SIGN IN AISLE AT THE R3 DOOR BROKEN. REPLACED EXIT LIGHT ASSEMBLY.SDR CALA2017090102965Battery Pack · inoperativeDURING EMERGENCY LIGHTS FUNCTIONAL TEST, FOUND THE BULLNOSE BIN EMERGENCY LIGHT POSITIONS 34LT, 29LT, 26LT, 23LT, 31RT, L4 DOOR EXIT SIGN AND AFT GALLEY RT EXIT SIGN INOPERATIVE. REMOVED & REPLACED THE BATTERY PACK M1273 AT THE LT AFT GALLEY & PERFORMED OPSSDR ASAA2017083121768Lens · missingFLIGHT ATTENDANTS REPORTED AN EMERGENCY EXIT LIGHT LENS MISSING. ACFT GROUNDED. REMOVED AND REPLACED EMERGENCY EXIT ROW LIGHT ASSY. OPS NORMAL IAW AMM 33-51-01-960-802.SDR R61A201708310649Light · fadedEMERGENCY LIGHT STRIP IN FRONT OF WARDROBE FADED. R & R THE LIGHT STRIP IAW AMM 33-50-21. OPS CHECKED GOOD.SDR AALA201709019013Lens · brokenEMERGENCY LIGHT LENS AT THE L1 DOOR IS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT LENS.SDR AALA201709019007Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT THE L1 DOOR. REPLACED THE LENS IAW AMM.SDR AALA201709019006Lamp · burned outEMERGENCY LIGHT IN FIRST CLASS LAVATORY IS BURNED OUT. REPLACED THE LAMP IAW AMM.SDR FDEA201708312416Battery Pack · inoperativeON PREFLIGHT ALL LEFT EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07-2. ALL LIGHTS OPS CHECKED GOOD.SDR DALA2017083106514Power Supply · disconnectedDURING A SERVICE CHECK, FOUND THE COCKPIT EMERGENCY LIGHT & AFT FACING EXIT SIGN OVER L1 JUMPSEAT INOPERATIVE. FOUND POWER SUPPLY B5-234 DISCONNECTED. CONNECTED AND OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2017083112586Battery Pack · dischargedFWD GALLEY AND ROW 8 EMER LIGHTS INOP. REPLACED BATTERY PACK NR 1.SDR MASA2017083112585Light · inoperative2 LAMPS INOP ROW 8 CEILING EXIT SIGN. PLACED ON MEL.SDR REXA2017083100949Bulb · inoperativeEMERGENCY EXIT LIGHTS IN GALLEY, LT LOWER, RT FWD & RT AFT HAVE BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-11.SDR DALA2017083106468Light · malfunctionedTHE FLIGHT CREW FOUND THEY COULD NOT CONTROL THE EMERGENCY PATHWAY LIGHTING IN THE CABIN: IT WOULD FLICKER ON AND OFF ON ITS OWN. MAINTENANCE CALLED IT AN ANOMALY AND DID NOT DO ANY FURTHER TROUBLESHOOTING.SDR SWAA2017090616160Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01674. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2017090616144Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01675. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2017090616143Cover · brokenAFT EMERGENCY EXIT LIGHT SWITCH GUARD COVER BROKEN. R&R COVER PER AMM.SDR AALA201709049013Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR ACROSS FROM THE R2 DOOR HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709049012Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR ACROSS FROM THE R5 DOOR HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709049011Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY LAVATORY 4F-LC HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709049010Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY LAVATORY 3F-RC HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709049009Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY SEAT 33D HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709049008Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY SEAT 4J HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709019022Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHT ON FLOOR BY SEAT 4D HAS A MISSING LENS COVER. RE-INSTALLED LENS COVER PER AMM 33-51-05. OPERATIONAL CHECK GOOD.
Back to JASC 3350