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 CALA2018012200288Lamp · inoperativeEMERGENCY LIGHT DISARM LIGHT LAMP INOPERATIVE. REPLACED THE LAMP IN THE EMERGENCY LIGHT DISARM SWITCH IAW AMM, OPS CHECKED GOOD.SDR CALA2018012200287Light · malfunctionedEMERGENCY LIGHTS ON, IN BACK 1/3 OF CABIN WITH THE SWITCH IN THE ARMED POSITION. COMPLETED SYSTEM RESET, EMERGENCY LIGHTING IN AFT CABIN OFF. IAW SSM 33- 51-15.SDR CALA2018012200293Lamp · inoperativeROW 20 SEAT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OK TO CONTSDR DALA2018012200327Fuse · failedSEAT EMERGENCY LIGHTS AT ROWS 31-36 FOUND INOPERATIVE. REPLACED THE FUSES FOR THE BATTERY PACK IAW AMM 33-53. CHECKED GOOD.SDR DALA2018012200326Battery Pack · inoperativeEMERGENCY LIGHTS IN THE TAIL SECTION FOUND INOPERATIVE. REPLACED THE BATTERIES, CHECKED GOOD IAW AMM 33-53.SDR AALA20180121007Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: MOUNTED EMERGENCY LIGHT ABOVE SEAT 17H AFT WAS INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-06-906-803 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180121006Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: L3 DOOR EXTERIOR EMERGENCY LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-06-960-803 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180122003Light · brokenEMERGENCY LIGHT ASSEMBLY AND LENS BROKEN AT SEAT ROW 14 DEF. REPLACED THE LIGHT ASSEMBLY AND LENS IAW AMM 33-51-04.SDR AALA20180122002Light · brokenEMERGENCY LIGHT ASSEMBLY AND LENS BROKEN IN THE AFT GALLEY. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA20180122001Light · brokenEMERGENCY LIGHT ASSEMBLY AND LENS BROKEN IN THE AFT GALLEY. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201801229034Cover · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER FELL OFF AT THE R1 LOCATION. MAINTENANCE REPLACED R1 EMERGENCY LIGHT ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018012300414Socket · shortedEMERGENCY LIGHT AT ROW 26 FOUND INOPERATIVE AT THE RT FWD OVERWING EXIT. THE LIGHT SOCKET FOUND SHORTED. REPLACED THE SOCKET IAW WDM 33-53. OK FOR SERVICE.SDR DALA2018012300413Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEATS 33 - 36. REPLACED THE POWER SUPPLY AND BATTERY PACK IAW AMM 33-51. CHECKED OK.SDR SWAA2018012419295Lens · detachedMID CABIN OVERHEAD EMERGENCY EXIT SIGN LENS DETACHED. INSTALLED THE LENS IAW AMM.SDR AALA201801239024Lens · missingL3 EXIT DOOR SIGN LENS MISSING. REPLACED THE SIGN IAW AMM 33-50-00. OK FOR SERVICE.SDR SWAA2018012319276Cover · looseRT EMERGENCY EXIT LIGHT COVER LOOSE AT ROW 12. SECURED COVER PER AMM.SDR SWAA2018012319256Battery Pack · dischargedAFT EMERGENCY EXIT "SERVICE DOOR" SIGN INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018012319255Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER AMM.SDR AALA201801229017Light · brokenAIRCRAFT WAS NOT GROUNDED. RIGHT AFT GALLEY DOOR EXIT SIGN BROKEN. REPLACED EMERGENCY EXIT LIGHT AT AFT GALLEY RIGHT SERVICE DOOR. PER MM 33-51-01SDR DALA2018012200385Light · brokenOVERHEAD AISLE EMERGENCY LIGHT IS BROKEN AT SEAT 19R. REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR REXA2018012100042Light · missingEMERGENCY LIGHT STRIP MISSING, NEXT TO 1A SEAT. REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-51-01.SDR DALA2018012200359Lens · damagedF/A REPORTED THAT THE AFT RIGHT EMERGENCY CEILING LIGHT LENS IS DAMAGED. MAINTENANCE REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51. OPS CHECKED SATISFACTORY.SDR AALA201801229033Lens · missingEMERGENCY LIGHT LENS BY THE R2 DOOR IS MISSING. REPLACED LENS IAW AMM 33-51-01.SDR DALA2018012200337Fuse · failedL1 DOOR EMERGENCY LIGHT INOPERATIVE. FOUND THE BATTERY PACK M1675 FUSE FAILED IAW WDM 33-51-12. R & R THE FUSE IAW MM 33-51.SDR AALA201801229007Light · inoperativeEMERGENCY LIGHT IN AISLE ABOVE THE L3 DOOR INOPERATIVE. REPLACED EMERGENCY LIGHT.SDR MASA2018012112928Light · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE.SDR CALA2018012100276Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT, AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04-960-801.SDR CALA2018012100274Battery Pack · inoperativeFWD ENTRY AND 1ST CLASS EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACKS IAW AMM 33-51-06.SDR CALA2018012100273Fuse · failedFWD EMERGENCY DOOR HATCH ON BOTH LEFT AND RIGHT SIDES HAVE LOWER INTERIOR EMERGENCY LIGHTS INOPERATIVE. FLOOR PATH EMERGENCY LIGHTS ROWS 15, 20, AND 21 ARE INOPERATIVE AS WELL, FOUND DURING AN OPS CHECK. A BAD FUSE ON THE BATTERY CHARGER FOR THE POWER SUPPLYSDR CALA2018012100272Lens · missingRIGHT WING EMERGENCY EXIT LOWER EXIT SIGN LENS IS MISSING. REPLACED THE LENS IAW 33-51-0 1.SDR CALA2018012100269Connector · disconnectedEMERGENCY LIGHT IN STOWAGE BIN AT SEAT 5B INOPERATIVE. TROUBLESHOT AND FOUND THE CONNECTOR D13466 DISCONNECTED AND A DUST CAP INSTALLED. CONNECTED THE CONNECTOR. OPS CHECKED GOODSDR CALA2018012100275Lamp · inoperativeAFT LEFT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW 33-51-04-960-801. OPS CHECKED GOOD.SDR ASAA2018012024068Lamp · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS, OP CHECKED GOOD IAW AMM 33-51-04.SDR AALA20180121008Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. AFT CABIN AISLE LT AND RT OVERHEAD CEILING MASTER CALL LIGHT/EXIT SIGN INOPERABLE. DOOR 4R FIVE EACH EXIT SIGN AND 1 CEILING LIGHT INOP AND 1 EMERGENCY LIGHT EXIT SIGN AT LAV 4F-L AND DOOR 4L INOPERABLE. REPLACED EMERGENCY POSDR AALA201801249013Lens · brokenAIRCRAFT WAS NOT GROUNDED: 4R EMERGENCY SIGN BROKEN. MAINTENANCE REPLACED 4R DOOR EXIT LENS COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180121002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: CIDS (1) EMERGENCY POWER SUPPLY UNIT (10WL) BATTERY FAULT OF EMERGENCY LIGHTS. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PACK (10WL) PER MM 33-581-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR YENA201801200040Epsu · failedEMERGENCY LIGHTS AT THE AFT OVERWING EXITS LT AND RT FAILED TO ILLUMINATE. REMOVED AND REPLACED EPSU 12WL, OPS CHECKED NORMAL IAW AMM 33-51-38. ACFT OK FOR SERVICE.SDR AALA201801239026Lens · missingR4 EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR DALA2018012200399Battery · dischargedFOUND EMERG LIGHT INOP AT ROW 43-45. FOUND BATTERY AND CHARGER M736 INOP. REPLACED BATTERY AND CHARGER BY AMM 33-51 OPS CHECKED GOOD.SDR SWAA2018012319277Sign · missingR2 DOOR EXIT SIGN MISSING. INSTALLED SIGN PER MM & SIP.SDR R61A201801200069Light · detachedEMERGENCY LIGHT STRIP NEAR SEAT 1D WAS DISCOVERED MISSING. FOUND AND SECURED.SDR REXA2018012000039Light · malfunctionedWHEN THE EMERGENCY LIGHT SWITCH IS PLACED IN THE ARMED POSITION, THE EMERGENCY LIGHTS COME ON AND WON'T GO OFF. PERFORMED A RESET PROCEDURE, ALL CHECKS WERE NORMAL IAW AMM 33-51-00.SDR DALA2018012200357Battery Pack · inoperativeDURING WALK AROUND, PILOT FOUND THE EMERGENCY LIGHTS L2-793 AND L2-794 TO BE INOPERATIVE. MAINTENANCE REPLACED THE B5-121 BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD AND THE AIRCRAFT WAS OK FOR SERVICE.SDR IPXA2018012225747Battery Pack · no testEMERGENCY LIGHT TEST FAILED, R & R BATTERY IAW AMM 33-51-01-401.SDR DALA2018012200324Battery Pack · inoperativeFOUND EMERGENCY LIGHTS ON CEILING INOPERATIVE AT SEAT ROW 27, 28, 29. CHANGED THE BATTERY PACKS IAW AMM 33-53. OK FOR SERVICE.SDR CALA2018012000262Light · unknownEMERGENCY LIGHTS DID NOT ILLUMINATE WHEN ARMED ON BATTERY POWER, WITH NO POWER ON ACFT. PERFORMED AN OPS TEST OF THE EMERGENCY LIGHTS IAW 33-51-00-710-00 1-A. GROUND CHECKED NORMALSDR CALA2018012000261Lamp · inoperativeAFT LT AND RT EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2018012000260Battery · weakEMERGENCY LIGHT BATTERY PACK AT CHARGER M1695 WEAK. REPLACED THE BATERY PACK IAW AMM 33-51-06, OPS CHECKED OK.SDR CALA2018012000259Battery · weakBATTERY FOR THE EMERGENCY LIGHT AT CHARGER M1675 FOUND WEAK. REPLACED THE BATTERY IAW AMM 33-51-06. OPS CHECKED OK.SDR CALA2018012000258Bulb · abnormalCEILING EMERGENCY LIGHT L1419 INOPERATIVE. CLEANED THE SOCKET AND REPLACED THE BULB. OPS CHECKED OK.
Back to JASC 3350