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 DALA2018040802247Clamp · disconnectedEMERGENCY ISLE LIGHT INOP AT SEAT 26CD. RECONNECTED WIRE BUNDLE CLAMP UNDER SEAT 26CD. OPS CK GD.SDR MASA2018040613115Light · inoperativeL1/R1 DOOR EMER EXIT SIGNS INOP. RELAMPED.SDR FDEA201804060874Light · inoperativeDURING A POST FLIGHT INSPECTION, THE L1 DOOR FWD EMERGENCY LIGHT ASSY LESS THAN 10% ILLUMINATED DURING A LIGHT TEST. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 33-50-00-2. EMERGENCY LIGHTS TESTED GOOD, OK FOR SERVICE.SDR DALA2018040602226Battery Pack · inoperativeEMERGENCY CEILING LIGHTS INOPERATIVE ABOVE ROWS 23-26. REPLACED THE BATTERY PACK AT B5104 IAW AMM 33-53. OPS CHECKED GOOD.SDR AALA201804119017Battery · inoperativeEMERGENCY POWER SUPPLY AFT BATTERY (13WL) WAS INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-38.SDR SWAA2018041021049Battery Pack · no testFORWARD RIGHT EMERGENCY BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2018041021048Battery Pack · no testFORWARD LT EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2018041021045Lamp · inoperativeRIGHT OVERWING EXIT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018041021023Charger · inoperativeAFT GALLEY ELECTRICAL BURNED ODOR AT LOCATION M1673. R & R THE BATTERY CHARGER IAW AMM.SDR SWAA2018041021021Lamp · inoperativeL2 EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018041021018Sign · detachedEXIT SIGN AT OVERWING FELL OFF. SECURED THE SIGN IAW AMM.SDR SWAA2018040521010Battery Pack · inoperativeFORWARD ENTRY EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR DALA2018040902288Connector · unsecureINTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. SECURED THE CONNECTOR FOR THE CEILING EMERGENCY LIGHTS AT 19FG.SDR SCNA20180405077Lens · crackedRT WING FWD OVERWING EMERGENCY LIGHT ASSY LENS CRACKED. REMOVED AND REPLACED LENS.SDR AALA201804089006Lens · detachedL2 DOOR, EXIT SIGN LENS DETACHED. SECURED THE SIGN LENS IAW AMM 33-50-00.SDR AALA201804089002Lens · missingL2 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW MM 33-25-00.SDR R61A201804050458Light · damagedFWD CABIN NEAR SEAT 1D EMERGENCY LIGHT STRIPS DAMAGED . R & R THE EMERGENCY LIGHT IAW AMM 33-50-21.SDR SIMA20180405002Light · inoperativeRIGHT WING FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SIMA20180405001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR CALA2018040601116Light · crackedEMERGENCY LIGHT FOUND CRACK AT SEATS 3F-3R. THE EMERGENCY LIGHT WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-05-960-802, REV 82.SDR CALA2018040601115Light · inoperativeSEAT 1D FWD EMERGENCY LIGHT FOUND INOPERATIVE. THE EMERGENCY LIGHT WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-05-960-802, AND AMM 33-51-05-710-002, REV 82.SDR CALA2018040601114Light · crackedLAVATORY DOORWAY, LT FLOOR PROXIMITY EMERGENCY LIGHT FOUND CRACKED. THE EMERGENCY LIGHT WAS REPLACED AND FOUND NORMAL IAW AMM 33-51-05-960-802, REV 82.SDR SIMA2018060400007Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT THE FA CEILING PANEL. REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT IAW AMM 33-50-08. OPS CHECKED GOOD.SDR SIMA2018060400008Bulb · inoperativeEMERGENCY EXIT ROW CEILING PANEL EMERGENCY LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE BULB IN THE EMERGENCY LIGHT IAW AMM 33-50-08. OPS CHECKED GOOD.SDR SIMA2018060400006Light · damagedLEFT EMERGENCY LIGHT STRIP EXTRUSIONS NR 1 THRU 8 WERE DAMAGED. REMOVED AND REPLACED THE LT EMERGENCY LIGHT IAW AMM 33-50-12.SDR AALA20180405006Lens · missingSEAT 6D EMERGENCY LIGHT LENS MISSING. REMOVED AND REPLACED THE EMERGENCYLIGHT ASSEMBLY. OPS CHECKED NORMAL IAW MM 33-51-05.SDR SWAA2018041021076Power Supply · inoperativeRIGHT OVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROW 6. R & R THE POWER SUPPLY IAW AMM.SDR AALA201804069007Lens · missingFLOOR EMERGENCY LIGHT LENS AT SEAT 11 D, E, F MISSING. INSTALLED THE LENS. OK FOR SERVICE.SDR AALA201804089005Lens · damagedL4 EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS IAW 35-50-00.SDR AALA201804069008Lens · missingEMERGENCY LIGHT LENS AT THE L2 DOOR WAS MISSING. INSTALL A LENS.SDR AALA201804069006Lens · missingEMERGENCY LIGHT LENS BY THE R4 DOOR IS MISSING. REPLACED EMERGENCY LIGHT IAW AMM 33-51-01-960-802. OPS TESTED GOOD, OK FOR SERVICE.SDR DALA2018040602244Housing · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED, REPLACED EMERGENCY EXIT LIGHT HOUSING AT 29C BELOW SEAT.SDR ASOA201804044019Battery Pack · dischargedIAH - DURING MAINTENANCE INSPECTION THE NUMBER FLOUR EMERGENCY LIGHT BATTERY PACK WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICESDR I5EA201804060001Battery Pack · dischargedMID CABIN EMERGENCY LIGHTS M1670 INOP AT STA 727C+13. REMOVED AND REPLACED BATTERY PACK (M1670) AT STA. 727C+13, TEST GOOD IAW AMM 33-51-06.SDR R61A201804040460Light · missingEMERGENCY LIGHT MISSING A SECTION AT SEAT 2A. SECURED THE EMERGENCY LIGHT SECTION IAW AMM 33-50-21.SDR IPXA2018040528212Lens · brokenEMERGENCY LIGHT LENS BROKEN, REPLACED THE LENS.SDR DALA2018040502203Switch · stuckCABIN EMERGENCY LIGHTS CAME ON DURING APPROACH AND STAYED ON UNTIL LANDING. MAINTENANCE FOUND THE SWITCH AT THE R2 DOOR STUCK, RELEASED AND CLEANED THE SWITCH. SYSTEM OPERATION IS NORMAL.SDR DALA2018040502202Light · inoperativeEMERGENCY LIGHTS ARE BURNED. MAINTENANCE REPLACED THE LIGHTS. SYSTEM OPERATION IS NORMAL.SDR SWAA2018040520986Lens · missingL1 DOOR EMERGENCY EXIT LIGHT COVER MISSING RED ARROW ON COVER AT LOWER AREA. R & R THE LENS IAW AMM.SDR JJBA20180404003Light · unknownEMERGENCY LIGHT INOPERATIVE AT ROW 18A. PERFORMED AN OPERATIONAL CHECK OF EMERGENCY LIGHT SYSTEM. OPS CHECK GOOD. NO OTHER DEFECTS NOTED.SDR MASA2018040413113Light · inoperativeROW 4 EMERGENCY LIGHT INOPERATIVE.SDR AALA20180404001Light · brokenAIRCRAFT WAS GROUNDED. SEAT 27H SEAT MOUNTED EMERGENCY LIGHT 0201720-003 FOUND BROKEN. REPLACED LIGHT PER AMM 33-51-10-962-104. OPERATIONS CHECK GOOD.SDR SWAA2018041021026Battery Pack · no testLEFT CABIN EMERGENCY LIGHT FAILED 15 MINUTE RUN TIME CHECK, BETWEEN BS 603 TO 727C+13. R & R THE BATTERY PACK IAW AMM.SDR AALA201804089013Lens · missingEMERGENCY LIGHT LENS MISSING FROM THE RIGHT OVERWING EXIT. INSTALLED A NEW LENS IAW MM 52-22-51.SDR AALA201804069005Lens · damagedLEFT AFT CABIN L4 DOOR EMERGENCY EXIT SIGN DAMAGED. REPLACED THE SIGN LENS IAW AMM 33-51-01.SDR AALA201804069004Lens · missingAIRCRAFT WAS NOT GROUNDED. 1L EXIT SIGN MISSING. REPLACED MISSING EXIT LENS AT 1L DOOR PER AMM 33-51-01.SDR DALA2018040502245Cover · looseEMERGENCY EXIT SIGN COVER LOOSE, SECURED EXIT SIGN COVER AT 1R.SDR AALA201804049027Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SEAT 23C INOPERABLE. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 23C AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180405003Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY POWER SUPPLY UNIT SYSTEM TEST, FOUND 13WL FAILED. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018040402220Lens · looseDURING INSPECTION, FOUND EMERGENCY LENS LENS LOOSE. MAINTENANCE SECURED THE LENS. OK FOR SERVICE.
Back to JASC 3350