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 SWAA2018091925390Switch · faultyRT OVERWING EMERGENCY EXIT LIGHT FAULTY. R&R SWITCH PER AMM.SDR DALA2018092005671Battery Pack · dischargedEXTERNAL EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHTING BATTERY PACK IAW AMM 33-55.SDR CALA2018091901974Battery · dischargedCABIN DOOR 4R EMER LIGHT OP TEST FAIL. CABIN DOOR 4R EMER LIGHT POWER SUPPLY BATTERY M33408 REPLACED & TEST RESULT NORMAL IAW AMM 33-51-06.SDR CALA2018091901969Epsu · failedREMOVE AND REPLACE THE EPSU (LT AFT). CHANGED DUE TO FAILED OPS TEST. TT 1247050 SN OFF 4328 IPC REFERENCE AMM POWER SUPPLY, C OFF 31-3350-9-9001 4328 ON 31-3350-9-9001 8109.SDR CALA2018091901965Lens · unknownEXIT SIGN AT SEAT 21A LOWER SIGN IS BROKEN. SECURED LENS ASSY.SDR FDEA201809182565Power Supply · inoperativeEMER LT BAT 1 LO ALERT. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY. OPERATIONAL CHECK NORMAL.SDR SWAA2018100925812Battery Pack · dischargedRT OVERHEAD BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROW 11 TO ROW 13. R&R BATTERY PACK PER AMM.SDR SWAA2018092425467Lens · missingL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2018092425457Cover · brokenAFT GALLEY EMERGENCY EXIT LIGHT SWITCH COVER SPRING BROKEN. R&R COVER PER WDM,SDR SWAA2018092425432Lens · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2018092025394Cover · crackedLT EMERGENCY FLOOR LIGHT COVER CRACKED AT ROW 28. R&R STRIP PER AMM.SDR REXA2018092400885Battery Pack · dischargedEMERGENCY BATTERY PACK 3 FAILS TO LIGHT MID CABIN FWD FACING CEILING EXIT SIGN. REMOVED, REPLACED BATTERY PACK 3 IAW AMM 33-51-04. OP CHECK OF EMERGENCY LIGHT BATTERY PACK GOOD IAW AMM 33-51-04-740-801.SDR AALA201809219011Battery · dischargedL1 DOOR OUTBOARD JUMP SEAT EMERGENCY FLASHLIGHT LOW ON POWER. REPLACED THE BATTERY IAW AMM 25-64-00, OPS CHECKED OK. OK FOR SERVICE.SDR AALA2018092109031Battery · no testEMERGENCY LIGHT POWER SUPPLY TEST SHOWED THE BATTERY 14WL FAILED. REPLACED THE POWER SUPPLY BATTERY. OPS CHECKED GOOD IAW AMM 33-51-38.SDR AALA201809209003Battery Pack · inoperativeDURING CARD N 2738 BATTERY REPLACEMENT, FOUND THE R1 DOOR BATTERY PACK WAS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 52-11-20. CHECKED OK.SDR AALA201809209010Power Supply · inoperativeEMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE POWER SUPPLY M33412 IAW AMM 33-51-06. SIGN OPS OK. AIRCRAFT OK FOR SERVICE.SDR DALA2018092005667Battery · dischargedEMERGENCY LIGHTS ON CEILING ARE INOPERATIVE THROUGHOUT THE MAIN CABIN. MAINTENANCE FOUND THAT THE BATTERIES AT OVERHEAD BIN 4D, E, 25D, E AND 29D, E WERE NOT CHARGED. THE BATTERIES IN THE POWER PACKS WERE REPLACED AND ALL EMERGENCY CEILING LIGHTS NOW WORK.SDR AALA201809209001Test Panel · malfunctionedNR 1 TEST DOES NOT ILLUMINATE BOTH LEFT AND RIGHT EMERGENCY LIGHTS. NR 2 TEST DOES TEST CORRECTLY (SQUIB TEST). THE AIRCRAFT WAS GROUNDED. REPLACED SQUIB TEST PANEL IAW MM 26-21-04. TEST CHECKED OK.SDR UIEA2018091802003Light · inoperativeCOCKPIT EMERGENCY LIGHT ASSY ABOVE DOOR INOP. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT ASSY IAW AMM 33-51-11. OPS CK GOOD.SDR IPXA2018091984133Bulb · inoperativeEMERGENCY LIGHT HAS FIVE BULBS INOPERATIVE. REPLACED THE FIVE BULBS IAW AMM 33-51-01-2.SDR MASA2018091811389Light · inoperativeROW 9 EMERGENCY CEILING LIGHT INOP. REPLACED BULB.SDR SWAA2018101826057Lens · crackedFORWARD CARGO BAY 3RD LIGHT FROM THE FORWARD BULKHEAD LENS CRACKED. R&R LENS PER AMM.SDR DALA2018092105699Battery Pack · dischargedBATTERY PACK ON M1210 EMERGENCY POWER SUPPLY FAILED CAPACITY CHECK. REPLACED BATTERY PACK, SYSTEM OPERATION IS NORMAL.SDR HALA2018091800223Light · inoperativeDOOR 1L EMERGENCY LIGHT INOP. RELAMPED DOOR 1L EMERGENCY LIGHT.SDR DALA2018091800222Sign · unsecureDOOR 2L EXIT SIGN DANGLING. SECURED DOOR 2L EXIT SIGN ASSEMBLY.SDR AALA201809209047Connector · damagedBOTH EMERGENCY LIGHTS WERE INOPERATIVE ON SEAT 13D. THE AIRCRAFT WAS GROUNDED. MAINTENANCE PINNED THE CONNECTOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00SDR AALA201809209043Cids · false indicationL1 DOOR, CIDS INDICATOR HAD 2 RED LIGHTS ILLUMINATED, NO COCKPIT ABNORMAL INDICATIONS. MAINTENANCE THE RESET CIDS AND PERFORMED SATISFACTORY OPERATONAL CHECK IAW AMM 23-73-01.SDR AALA201809209016Power Supply · faultyCIDS1 MESSAGE FOR THE EMERGENCY POWER SUPPLY UNIT 13WL. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA201809209015Seal · brokenL3 DOOR FLIGHT ATTENDANT EMERGENCY FLASHLIGHT TAMPER SEAL WAS BROKEN. REPLACED THE TAMPER SEAL.SDR SWAA2018092025360Light · inoperativeLT EMERGENCY EXIT LIGHT INOP AT ROW 9. RELAMPED LIGHT PER AMM.SDR SWAA2018091925359Lens · unsecureFORWARD EMERGENCY EXIT LIGHT LENS FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR YENA2018092070349Power Unit · failedFLT 2680, EWR-BOS. EMERGENCY LIGHT AT CEILING PANEL NR 13 INOP. R&R EMERGENCY LIGHT POWER UNIT NR 5 IAW AMM 33-50-01. OPS CHECK GOOD.SDR ASAA2018091926180Battery Pack · failedBATTERY CHARGER FAILS TO CHARGE BATTERY FOR LT ROWS 6-11 AND OUTSIDE LT OVERWING (FWD LIGHT) (M2335). GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK AND OPS CK GOOD IAW AMM 33-51-06-960-805.SDR ASAA2018091726177Sign · missing16F EXIT/SALIDA SIGN MISSING. GROUNDED - YES. FOUND & SECURED "E" EXIT SIGN AT 16F OK FOR SERVICE.SDR DALA2018091905657Fuse · blownFOUND EMERGENCY LIGHT OUT AT 23-26. R&R FUSE AT BATTERY M10657, OPS CHK OK REF AMM 33-51.SDR AALA201809199009Power Supply · no testPOWER SUPPLY 10WL FAULTED ON A CIDS TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED OK.SDR AALA201809189019Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. FOUND R4 DOOR EXIT AND RT AFT CEILING (AFT OF SEAT 32) EMERGENCY LIGHT OUT. REPLACED R4 EMERGENCY LIGHT POWER SUPPLY PER AMM 33-51-06.SDR SIMA201809187005Inverter · inoperativeEMEREGENCY EXIT LIGHTED SIGN ON BACKSIDE OF AFT CALLEY (FACING THE SEATS) INOP. REMOVED AND REPLACED NR 2 DC/AC INVERTER IAW AMM 33-50-11 AND EMERGENCY LIGHTS OPS CHECK GOO IAW AMM 33-50-00-700-801.SDR AALA20180918002Battery Pack · no testEPL ON ROWS 16-20 WILL NOT STAY ON FOR THE TEST IAW CARD 2908. REPLACED THE BATTERY PACK IAW AMM 33-51-06. PROXIMITY LIGHTS FOR ROWS 16-20 TEST GOOD.SDR CALA2018091701948Battery · dischargedDOOR R4 EMER LT POWER SUPPLY M3 3409 BATTERY PACK LOW CAPACITY. DOOR R4 EMER LIGHT POWER SUPPLY M33409 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06. INSPECTION OK.SDR CALA2018091701947Battery · dischargedDOOR R3 EMER LT POWER SUPPLY M3 3404 BATTERY PACK LOW CAPACITY. DOOR R3 EMER LIGHT POWER SUPPLY M33404 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06. INSPECTION OK.SDR RAIA201809170001Light · inoperativeINOP EMERGENCY UPPER INNER LIGHT NEAR RH EMERGENCY EXIT. R&R EMER LIGHT ASSEMBLY OPS CHECK GOOD.SDR MASA2018091711376Light · inoperativeROW 18 CEILING EMER FLOOD LIGHT INOP.SDR SWAA2018092025400Lens · missingLT OVERHEAD BIN EMERGENCY EXIT LIGHT MISSING CLEAR LENS AT ROW 9. INSTALLED LENS IAW AMM.SDR AALA201809209034Light · unknownFOUND TWO CEILING EMERGENCY LIGHTS INOPERATIVE. ONE AT ROW 9 AND ONE AT ROW 24. PERFORMED OPERATIONAL CHECK OF CABIN EMERGENCY LIGHTS IAW AMM 33-51-00-710-063-A. OPS CHECKED GOOD.SDR SWAA2018091925379Sign · unsecureMID CABIN OVERHEAD EMERGENCY EXIT SIGN FELL. SECURED SIGN PER AMM.SDR YENA2018092060350Light · inoperativeFLT 467, ATL-FLL. EMERGENCY EXIT LIGHT OVER DOOR 2L INOP. RELAMPED EMERGENCY EXIT LIGHT ASSY OVER L2 DOOR AND TESTED IAW AMM 33-51-00, OPS CHK NORMAL.SDR SWAA2018091725146Cover · missingFORWARD EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER PER MM.SDR DALA2018091905656Battery Pack · dischargedL2 DOOR EXIT SIGN LIGHT INOP W/ EMERGENCY LIGHTS TEST. R&R L2 DOOR EMERGENCY BATTERY PACK IAW AMM 33-55 OPS NML. A/C OK FOR SERVICE.SDR CALA2018091901951Battery · dischargedC/O EMER LIGHT TEST FOUND BATTERY M33404 INOP AT DOOR 3 RT. REPLACED THE BATTERY M33404 AT DR3 RT AND CO EMER LIGHT OP TEST FOUND NORMAL REF AMM 33-51-06-960-802 AND AMM 33-51-00-710-801 REV 83.
Back to JASC 3350