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 SWAA2017071114958Fuse · blownR2 DOOR EMERGENCY LIGHT INOP. R&R FUSE PER WDM.SDR SWAA2017071114957Light · inoperativeR2 DOOR EMERGENCY EXTERIOR LIGHT INOP. RELAMPED LIGHT PER WDM.SDR SWAA2017071114956Fuse · blownR2 DOOR EMERGENCY EXTERIOR LIGHT INOP. R&R FUSE PER WDM.SDR SWAA2017071114943Lens · looseL1 DOOR EMERGENCY LOCATOR SIGN LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2017071114935Light · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER WDM.SDR SWAA2017071114925Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS COVER LOOSE. SECURED LENS PER AMM.SDR R61A201707070524Power Supply · inoperativeEMERGENCY LIGHT INOPERATIVE IN FIRST CLASS SECTION. R & R THE NR 2 ELPU IAW AMM 33-50-01. PERFORMED ELPU FULL CHARGE IAW AMM 33-50-01.SDR AALA201707109047Battery · no testCIDS 1 TEST MESSAGE 335100 BATTERY, EMERGENCY POWER SUPPLY UNIT 13WL. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY 13WL IAW AMM 33-51-38.SDR AALA201707109042Battery · no testDOOR EPSU BATTERY FAILED TO TEST. REPLACED EPSU BATTERY.SDR AALA201707109041Battery · failedDOOR EPSU BATTERY FAILED TO TEST. REPLACED THE BATTERY.SDR AALA201707109038Lens · unsecureCOVER ON EMERGENCY LIGHT AT THE L3 JUMPSEAT FELL OFF. SECURED THE LENS.SDR DALA2017070905319Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED. REPLACED SEAT MOUNTED LIGHTS.SDR AALA201707109057Lens · damagedEMERGENCY EXIT LIGHT AT THE L2 DOOR IS DAMAGED. REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SIMA20170707001Battery Pack · inoperativePILOT REPORTED EMERGENCY LIGHTS WILL NOT STAY ON. REMOVED AND REPLACED ALL EMERGENCY LIGHT BATTERIES IAW AMM 33-51-17. OPS CHECKED GOOD NO FURTHER DEFECTS NOTED.SDR SWAA2017071014896Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R & R BATTERY PACK IAW AMM.SDR SWAA2017071014895Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01694. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017071014885Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017071014884Cover · looseFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED THE COVER IAW SIP.SDR SWAA2017071014841Lens · looseRIGHT EMERGENCY AISLE LIGHT LENS COVER LOOSE BETWEEN ROW 13 TO ROW 14. SECURED THE LENS IAW SIP.SDR AALA201707109028Lens · missingEXIT LIGHT COVER ROW 25D MISSING.SDR AALA201707109027Wire · brokenSEAT ROW 1 LT EMERGENCY LIGHT INOPERATIVE. FOUND A BROKEN WIRE AND LOOSE CONNECTOR.SDR AALA201707109024Lens · damagedAFT EXIT DOOR MISSING PART OF EXIT SIGN COVER. SECURED BOTH AFT DOOR EMERGENCY LENS COVER.SDR DALA2017070805271Lamp · inoperativeRT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, CHECKED GOOD.SDR DALA2017070705270Light · inoperativeSEAT 29 MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-53. OPS CHECKED OK.SDR DALA2017070705269Fuse · failedEMERGENCY FLOOR LIGHTS IN FWD CABIN WILL NOT TURN ON. REPLACED FUSES ON THE BATTERY PACK. EMERGENCY FLOOR LIGHTS IN FWD CABIN WORK GOOD. OK FOR SERVICE.SDR A6WA201745087Light · brokenEMERGENCY FLOODLIGHT MOUNTED ON THE WARDROBE BASE IS BROKEN. REMOVED AND REPLACED THE FLOODLIGHT ASSY. CHECKED GOOD.SDR MASA2017070712447Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT NEAR FWD LAVATORY INOPERATIVE.SDR KO0R201707070033Light · inoperativeRIGHT FORWARD DOOR EMERGENCY LIGHTS L2-480 & L2-481 ARE INOPERATIVE.SDR KO0R201707070032Light · inoperativeRIGHT FORWARD DOOR HANDLE EMERGENCY LIGHT IS INOPERATIVE.SDR DALA2017070705245Battery Pack · dischargedEMER CEILING LIGHTS INOP FROM ROW 16-20. REPLACED BATTERY PACK AT B5-102 REF AMM 33-53. OPS CHECK GOOD.SDR AALA201707109051Connector · damagedEMERGENCY AISLE LIGHTING INOPERABLE AT SEATS 24C AND 25C. FOUND DAMAGE TO BACKSHELL SUPPORT ASSEMBLY WHICH RESULTED IN DAMAGE TO CONDUCTORS. REPLACED EMERGENCY AISLE LIGHTING CONNECTOR BACK SHELL. CONNECTOR SECURED, EMERGENCY LIGHTS OPS NORMAL IAW AMM 33-51-0SDR SIMA20170706004Light · inoperativePAX DOOR EMERGENCY LIGHT INOP. RECONNECTED PAX DOOR EMERGENCY LIGHT AS REQUIRED. OPC GOOD.SDR DALA2017080405969Light · inoperativeDURING INSPECTION FOUND EMERGENCY AISLE LIGHT BELOW OVERHEAD BIN INOP AT 10ABC. MAINTENANCE REPLACED LED AISLE LIGHT AT OVERHEAD BIN 10 ABC OK FOR SVC PER AMM 33-51.SDR REXA2017070600781Battery Pack · inoperativeLEFT AND RIGHT OVERWINGS MID EMERGENCY LIGHTS INOPERATIVE. REPLACED THE NR 3 BATTERY PACK IAW AMM 33-51-04, AND OPS CHECKED GOOD IAW AMM 33-51-04.SDR SWAA2017071114940Lens · discoloredRT DOOR OVERHEAD EMERGENCY EXIT PANEL LIGHT LENS DISCOLORED. R&R LENS PER MM.SDR SWAA2017071114919Lens · discoloredLT DOOR OVERHEAD EMERGENCY EXIT PANEL LIGHT LENS DISCOLORED. R&R LENS PER MM.SDR AALA201707109045Lens · missingEMERGENCY LIGHT BY THE R2 DOOR IS MISSING A LENS. REPLACED THE LENS IAW MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017070705316Battery Pack · no testDURING EPSU BATTERY TEST FAILED AT THE L3 AND L4 DOORS. REPLACED EPSU BATTERY.SDR AALA201707079008Lens · missingMISSING LENS ON DOOR EMERGENCY LIGHT ASSY BY THE L3 DOOR. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201707079007Light · crackedCRACKED EMERGENCY LIGHT ASSEMBLY BY THE R1 DOOR. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-13.SDR DALA2017070705311Battery Pack · inoperativeFOUND MID FWD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2017071014860Lens · brokenFORWARD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. INSTALLED LENS IAW AMM.SDR DALA2017070705267Fuse · failedDURING SERVICE CHECK, EMERGENCY LIGHTS AT SEAT ROWS 24 TO 30 INOPERATIVE. TROUBLESHOT IAW WDM 33-51-14. FOUND A BAD FUSE F-2 AT THE B5-212 BATTERY PACK. REPLACED THE FUSE, OPS NORMAL.SDR AALA20170706008Battery Pack · faultyEXIT LIGHT ABOVE THE L4 DOOR STAYS ON WITH SWITCH IN OFF POSITION. REPLACED L AFT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201707079010Battery · no testEMERGENCY LIGHTS WILL NOT TURN ON AT ROW 22 RT AND LT. REPLACED BATTERY POWER SUPPLY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA201707079005Lens · missingEMERGENCY EXIT LIGHT UNDER AFT JUMPSEAT, THE LENS WAS MISSING. REPLACED THE LENS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20170706002Sign · inoperativeFWD FACING EMERGENCY EXIT SIGN IN MID CABIN INOPERATIVE. REMOVED AND REPLACED AND OPS CHECKED GOOD IAW AMM 33-50-15.SDR REXA2017070600772Lamp · inoperativeFWD RIGHT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW CMM 33-52-06. OPS CHECKED GOOD.SDR MASA2017070612443Light · inoperativeROW 20 EMERGENCY FLOODLIGHT INOP. REPLACED BULB.SDR DALA2017070605217Battery Pack · inoperativeLOWER LT & RT AFT OVERWING EXIT LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.
Back to JASC 3350