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 SWAA2016093008305Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR MASA2016092912428Light · inoperativeEMERGENCY LIGHT STRIP BELOW SEAT 1C INOPERATIVE. MX SECURED THE STRIP OPS NORMALSDR MASA2016092912427Battery Pack · dischargedCABIN EMERGENCY LIGHTS WILL NOT STAY ON. CHARGED BATTERY PACKS.SDR CALA2016092900706Charger · inoperativeEMERGENCY EXIT LIGHTS INOP ROWS 20 AND 21 R+R M1694 BATTERY AND CHARGER. OPS CHECK GOOD.SDR CALA2016092900705Lamp · inoperativeEMERGENCY LIGHT AT 27D OVERHEAD BIN INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR MASA2016092912424Bulb · inoperativeFLOOR LEVEL EMERGENCY FLOOD LIGHT RIGHT OVER-WING EXIT HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2016092912425Light · inoperativeROW 18 EMERGENCY FLOOR FLOOD LIGHT INOPERATIVE.SDR QXEA2016092900624Lamp · inoperativeEMERGENCY LIGHTS, CAUTION ADVISORY LIGHTS PANEL BACKLIGHTING IS INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR SWAA2016100508467Lens · detachedFORWARD EXIT SIGN COVER LIGHT LENS DETACHED. R & R THE LENS IAW AMM.SDR DALA2016092907031Light · inoperativeEMERGENCY LIGHTING DAMAGED OR INOPERATIVE. SECURED LIGHT HOUSING AT 23D. (2701932)SDR DALA2016093007016Light · inoperativeEMERGENCY ESCAPE PATH MARKING SYSTEM SEAT MOUNTED LAMPS SEAT 29 DEF ONE WHITE INOP. REPLACED LIGHT SHROUD ASSY REF AMM 25-25. EMERGENCY LIGHTS OPS NORMAL. MEL AND PLACARD REMOVED.SDR AALA201609309019Cover · detachedAFTER TAKEOFF, THE EMERGENCY EXIT (OVERWING LEFT) DOOR WARNING AND THE FLIGHT RETURNED TO DEPARTURE. (NO EMERGENCY WAS DECLARED). MAINTENANCE FOUND THE COVER FOR LEFT OVER WING EMERGENCY EXIT HAD FALLEN OFF AND REINSTALLED IAW TSM 52-21-00-810-A. NO FAULTS NOTSDR AALA201609309015Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR 4R EXIT LIGHT COVER MISSING. REPLACED LENS PER AMM 33-51-13.SDR SIMA20160928003Power Supply · inoperativeFWD EMERGENCY LIGHTS INOP. R&R EMERGENCY LIGHTING SYSTEM POWER SUPPLY NR 1 IAW WC 33-700-19. OPS GOOD.SDR SIMA20160928004Battery · disconnectedSEVERAL EMERGENCY SIGNS AND LIGHTS INOP, EXTERIOR LIGHT FWD OF LT WING, MAIN DOOR LIGHT, MAIN ENTRANCE OVERHEAD LIGHT & FWD CABIN EXIT SIGN. FOUND EMERGENCY BATTERY 1 UNINSTALLED ON COMPARTMENT FLOOR. REINSTALLED BATTERY 1 IN REFERENCE WITH 33-50-04-400-801-SDR SWAA2016093008303Light · inoperativeRT MOST AFT EMERGENCY FLOOR TRACK FLUORESCENT STRIP INOP. R&R STRIP PER AMM.SDR SWAA2016093008302Strip · wornFORWARD CABIN EMERGENCY FLOOR TRACK FLUORESCENT LIGHTING STRIP WORN. R&R STRIP PER AMM.SDR SWAA2016093008298Battery · defectiveLT AFT OVERWING EMERGENCY LIGHT CHARGER CIRCUIT BREAKER P18-3 A10 POPPED. R&R BATTERY PER AMM.SDR REXA2016092801833Battery · dischargedNR 1 EMERGENCY BATTERY DEAD. REPLACED EMERGENCY BATTERY NR 1 IAW AMM 33-51-17. OPS CHECK GOOD.
SDR AALA20160930001Cover · damagedAIRCRAFT WAS GROUNDED. R1 DOOR EMERGENCY EXIT IDENTIFIER COVER IS DAMAGED. REMOVED AND REPLACED EXIT IDENTIFIER ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK NORMAL.SDR AALA20160929003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. AFT EMERGENCY PATH LIGHTS DIM WHEN TESTED WITH BATTERY PACK AB5-4. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-60-98. SYSTEM CHECKS NORMAL.SDR AALA20160929002Battery · dischargedAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY LIGHTS IN 1ST CLASS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY ASSEMBLY FOR 1ST CLASS OVERHEAD LIGHTS IAW AMM 33-53-00. OPERATIONAL CHECK NORMAL.SDR SWAA2016092908290Light · disconnectedLEFT SIDE SECOND FROM LAST BULLNOSE EMERGENCY LIGHT DISCONNECTED. RECONNECTED LIGHT IAW SIP.SDR SWAA2016092908281Lens · looseL1 DOOR FORWARD WALL EMERGENCY EXIT LIGHT COVER LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2016092908271Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R & R BATTERY PACK IAW DWG.SDR MASA2016082812423Lamp · inoperativeROW 21 EMERGENCY CEILING FLOODLIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2016092812422Lamp · inoperativeROW 18 EMERGENCY CEILING FLOODLIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2016092812421Light · inoperativeROW 15 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR HNAA2016092800299Bulb · inoperativeSIDEWALL EMERGENCY EXIT LIGHT IS INOPERATIVE ON LEFT SIDE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2016092800298Bulb · inoperativeEMERGENCY FLOOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR YENA20160928872Battery Pack · failedDURING MAINTENANCE, EMERGENCY LIGHT WAS TESTED AND FAILED TEST. R & R BATTERY PACK AT FORWARD 10WL AND AFT 13WL IAW AMM 33-51-38. PERFORMED SECOND TEST. LIGHT PASSED.SDR YENA20160928871Battery Pack · failedDURING MAINTENANCE, EMERGENCY LIGHT WAS TESTED AND FAILED TEST. R & R BATTERY PACK AT FORWARD, 10WL AND AFT, 13WL IAW AMM 33-51-38. PERFORMED SECOND TEST. LIGHT PASSED.SDR DALA2016100407075Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD.SDR UIEA2016093000790Light · inoperativeLT EMERGENCY EXTERIOR EGRESS LIGHT INOP. RELAMPED THE LT EMERGENCY EGRESS LIGHT OPS CHECK NORMAL IAW AMM 33-51-28.SDR SIMA20160927001Lamp · inoperativeUPPER RT WING EMERGENCY LIGHT IS INTERMITTANT. R & R THE LAMP. OPS TESTED OK IAW AMM 33-50-10.SDR SIMA20160927002Sign · inoperativeCREW REPORTS RT CABIN EMERGENCY DOOR FLOOR LEVEL EXIT SIGN PARTIAL BURNED OUT. OPS CHECKED PERFORMED IAW AMM 33-51-00. OPS CHECKED GOOD.SDR SWAA2016092908275Sign · looseRIGHT EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2016092908273Battery Pack · faultyCABIN EMERGENCY EXIT LIGHTS STAY ON WITH THE COCKPIT SWITCH IN THE ARMED POSITION. PULLED AND RESET EMERGENCY LIGHT CIRCUIT BREAKER. R & R BATTERY PACK IAW AMM.SDR QXEA2016092900623Lamp · inoperativeGREEN NORMAL LIGHT ON THE MAIN CABIN DOOR EMERGENCY LIGHT SWITCH NOT ILLUMINATED. REPLACED THE LAMP NORMAL LIGHT SWITCH. OPERATES NORMALLY. RETURNED TO SERVICE.SDR DALA2016092806938Fuse · inoperativeFOUND EXTERIOR EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW WDM 3351. R & R THE FUSE IN POWER SUPPLY M730, R & R 1 FUSE IN POWER SUPPLY M10568, AND R & R THE FUSE IN POWER SUPPLY M737 IAW SWPM 20. CHECKED GOOD.SDR DALA2016092806937Bulb · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM33-51-06-962-001-002. OPS CHECK GOOD.SDR SWAA2016092808256Battery Pack · no testEMERGENCY LIGHTS BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808255Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808254Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808253Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808252Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808251Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016092808241Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R &R THE BATTERY PACK IAW AMM.SDR AALA20160927008Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA20160927007Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.
Back to JASC 3350