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 SWAA2019120239250Tray · bentPASSENGER CABIN EMERGENCY EXIT LIGHT BATTERY TRAY BENT AT BS. 322, RBL 7. / R&R BATTERY IAW AMM.SDR DALA2019120206971Power Supply · malfunctionedTHE AFT CATWALK AND AFT EMERGENCY EXIT DOORWAY LIGHTS ARE FLICKERING ON AND OFF. MAINTENANCE REPLACED THE AFT CATWALK EMERGENCY POWER SUPPLY IAW B717 AMM 33-51-03. OPERATIONAL TEST WAS GOOD. (LP #6607820)SDR DALA2019120206970Light · inoperativeTHE EMERGENCY LIGHTS IN THE FIRST CLASS SECTION ARE INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY PER B-717 AMM 33-51. ALL EEPL CHECK GOOD NOW. (LP #6630556)SDR DALA2019120206969Battery · failedWHILE PERFORMING WC #3351-2001, MAINTENANCE FOUND ONE EMERGENCY LIGHT BATTERY TO BE BAD FROM STOCK. INSTALLED ORIGINAL EMERGENCY LIGHT BATTERY (B5-227) IAW B717 AMM 33-51. DEFERRED FOR 40 FLIGHT HOURS. 28NOV19 DTW - THE EMERGENCY LIGHT BATTERY PACK (B5-227) WASDR VNAA2019112971101Connector · disconnectedLH AFT EXTERIOR EMERGENCY LIGHT INOP. DEFERRED LH AFT EMERGENCY EXIT LIGHT. REMOVED AND RPELACED LH AFT EXTERIOR EMERGENCY LIGHT IAW 33-51-15-000/400-801. NO FIX. CHECK AND FOUND CONNECTOR J877/P877 NOT CONNECTED. CONNECTED AND OPS CHECK IAW 33-51-00-710-802. SDR SWAA2019112939224Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. / R&R BATTERY PER MM.SDR SWAA2019112939223Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. / R&R BATTERY PER MM.SDR SWAA2019112939222Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. / R&R BATTERY PER MM.SDR SWAA2019112939211Light · looseCENTER AISLE OVERHEAD EMERGENCY EXIT SIGN AT MID CABIN LOOSE. / R&R LIGHT HOUSING ASSEMBLY IAW AMM.SDR SWAA2019112939208Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R&R BATTERY PER MM.SDR SWAA2019112939205Lamp · inoperative
L/H EMERGENCY LIGHT INOP AT SEAT ROW 7. / RELAMPED LIGHT PER AMM.SDR AALA201911289003Battery Pack · faultyAIRCRAFT NOT GROUNDED: EMER LT INOP BY CREW ATT REST MODULE. LH AND RH FWD SECTION. REPLACED BATT PWR PACK M33400 AND EMER LIGHT LH AND RH SECTON CREW REST MODULE CKS OK IAW AMM 33-51-06.SDR SWAA2019120439333Cover · missingFIRST OFFICER'S FORWARD EMERGENCY EXIT SIGN COVER MISSING. / R&R COVER PER SIP.SDR DALA201912037015Charger · inoperativeDURING SERVICE CHECK FOUND SEATS 1A-5A EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED PACK CHARGER M9008. SYSTEM OPERATION IS NORMAL.SDR SWAA2019120339273Light · inoperativeR1 DOOR EXIT LOCATOR SIGN INOP. / R&R LIGHT ASSEMBLY PER AMM.SDR ASOA2019120265115Sign · inoperativeDURING MX INSPECTION THE EMERGENCY EXIT SIGN AT ROW 3CD WAS INOP. MX REMOVED AND REPLACED THE EXIT SIGN WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR VNAA2019112861101Battery Pack · dischargedEMERGENCY BATTERIES LEFT ON ALL NIGHT. REMOVED AND REPLACED EPSU BATTERY PACK IAW CRJ 700 AMM. OPS CHECK GOOD AT THIS TIME / #1 POWER SUPPLY BATTERY P/N AD2013-1A S/N 231815, #2 BATTERY P/N 2013-1A S/N 104602, #3 BATTERY P/N AD2013-1A S/N 68782, #4 BATTERY 2SDR DALA2019112866953Light · detachedDURING SVC CK FOUND EMERGENCY PATHWAY LIGHT ASSY AT SEAT 22C HANGING DOWN, REATTACHED SEAT 22C EMERGENCY LIGHT HOUSING WITH SERVICEABLE HARDWARESDR AALA201911279007Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 10WL EPSU CLASS 1 FAULT. REMOVED AND REPLACED 10WL EPSU BATTERY PACK IAW AMM 33-51-38. OPS CHECK NORMAL.SDR AALA201911279008Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 15WL EPSU CLASS I FAULT. REMOVED AND REPLACED 15WL EPSU BATTERY PACK IAW AMM 33-51-58. OPS CHECK NORMAL.SDR AALA201911279009Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 14WL EPSU CLASSS 1 FAULT. REMOVED & REPLACED 14WL EPSU BATTERY PACK IAW AMM 33-51-38. OPS CHECK NORMAL.SDR AALA201911279010Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 13WL EPSU CLASS I FAULT. REMOVED AND REPLACED 13WL EPSU BATTERY PACK IAW AMM 33-51-58. OPS CHECK NORMAL.SDR AALA201911279011Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 12WL EPSU CLASS I FAULT. REMOVED AND REPLACED 12WL EPSU BATTERY PACK IAW AMM 33-51-58. OPS CHECK NORMAL.SDR AALA201911279012Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS 11WL EPSU CLASS 1 FAULT. REMOVED & REPLACED 11WL EPSU BATTERY PACK IAW AMM 33-51-38. OPS CHECK NORMAL.SDR CALA2019112702093Charger · inoperativeTEST FOUND LH DR NO.3 EMER LIGHT POWER SUPPLY M33405 INOP.SDR SIMA201911276004Light · inoperativeRH FWD FLOOR PROXIMITY LIGHT STRIP DOES NOT FULLY ILLUMINATE.-C/A-REMOVED AND REPLACED RH FWD FLOOR PROXIMITY LIGHT STRIP IAW EMB 175 AMM 33-50-21.SDR SIMA201911276005Battery Pack · inoperativeFWD SERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT POWER UNIT #1 IAW AMM 33-50-01 OPS CHK GOODSDR SWAA2019112739174Light · looseL/H SIDE PHOTO LUMINESCENT FLOOR LIGHTING WAS STICKING UP AT ROW 8. / SECURED PHOTO LUMINESCENT FLOOR STRIP IAW SIP.SDR MASA2019112642159Lamp · inoperativeCEILING EMERGENCY LIGHT ABOVE ROW 21 INOP- RELAMPEDSDR 2019FA0000385Battery Pack · dischargedRH OVERWING EMERGENCY LIGHTS INOP.SDR SWAA2019112739180Battery Pack · dischargedSUPPLEMENTAL INFORMATION, LT EMERGENCY LIGHTING ON OVERHEAD BIN BULLNOSE INOP AT ROW 14. R&R BATTERY PACK PER AMM.SDR SWAA2019112739179Battery Pack · dischargedSUPPLEMENTAL INFORMATION, LT EMERGENCY LIGHTING ON OVERHEAD BIN BULLNOSE INOP AT ROW 9. R&R BATTERY PACK PER AMM.SDR SWAA2019112739178Battery Pack · dischargedSUPPLEMENTAL INFORMATION, LT EMERGENCY LIGHTING ON OVERHEAD BIN BULLNOSE INOP AT ROW 7. R&R BATTERY PACK PER AMM.SDR SWAA2019112739177Cover · brokenSUPPLEMENTAL INFORMATION, AFT GALLEY EMERGENCY LIGHT SWITCH COVER BROKEN. R&R SWITCH COVER ASSEMBLY IAW MM.SDR SWAA2019121239573Baffle · crackedAFT CARGO BAFFLE CRACKED BETWEEN BS. 927 TO BS. 947, RBL 22. / R&R BAFFLE IAW DWG & SRM.SDR DALA2019120397019Light · wrong partEMERGENCY LIGHTS AT SEAT 30AB ARE RED SHOULD BE WITH. FOUND WRONG LIGHT ASSEMBLY INSTALLED AT ROW 30 AB. REPLACED WHITE LENS WITH RED LIGHTS. SYSTEM OPERATION IS NORMAL.SDR REXA2019120251713Bulb · inoperativeFWD OVERWING EMERGENCY EXIT BULB IS INOP
REMOVED AND REPLACED BULB IAW AMM 33-51-21 OPS CHECK GOODSDR DALA2019112976956Light · misinstalledDURING CABIN CHECK FOUND EXIT MARKER AT ROW 33 INSTALLED UPSIDE. REMOVED EXIT IDENTIFIER ON AFT OF SIGN AND INSTALLED CORRECTLY.SDR VNAA2019112951105Light · failedLH FWD EXTERNAL EMERGENCY LIGHT INOP. R+R LH FWD EXTERNAL EMERGENCY LIGHT IAW CRJ200 AMM. OPS CHECK GOOD.SDR CALA2019112862079Battery · inoperativeFIRST CLASS EMERGENCY PATH ESCAPE LIGHTING INOP COACH LIGHTING OK. REMOVED AND REPLACED EMERGENCY LIGHT (M1674) PACK BATTERY AND POWER SUPPLY REF AMM 33-51-06. OPS CHECK NORMAL.SDR AALA2019112769005Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, CIDS TEST EMERGENCY LIGHTS BATTERY 15WL FAILED. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PER MCM 2735.SDR CALA2019112702091Light · crackedTHE FLOOR PROXIMITY LIGHT ON OFCR L/H FWD LOWER ATTACHMENT WAS C RACKED, REF NON-ROUTINE NO.9491250, REPLACED THE FLOOR PROXIMITY LIGHT ON OFCR L/H FWD LOWER ATTACHMENT, PERFORMED OPERATIONAL TEST OF EME RGENCY LT, THE RESULT WAS ''SATIS'' REF TO AMM 33-51SDR SWAA2019112739191Lamp · inoperativeR/H OVERWING EXIT EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019112739173Light · unsecureL/H EMERGENCY TRACK LIGHTING NOT SECURE AT ROW 9. / INSTALLED LIGHT CORRECTLY PER MM.SDR SWAA2019112639141Light · brokenCENTER EMERGENCY EXIT LIGHT BROKEN. / R&R LIGHT ASSEMBLY PER AMM.SDR DALA2019112606920Power Supply · faultedDURING C CHECK, EPSU A DOOR 4L FIN 17WL SELF TEST RESULTED WITH UNIT FAULTY. REPLACED EPSU. LP 1374520SDR MASA2019112512158Bulb · inoperativeFWD LWR SVC DOOR EMER BULB INOP
REPLACED BULBSDR AALA201911259051Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 5H FORWARD ESCAPE PATH LIGHTING INOPERATIVE. REPLACED ESCAPE PATH LIGHT ASSEMBLY PER AMM 33-51-05.SDR MASA2019112542157Lamp · inoperativeROW 1 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP- RELAMPEDSDR DALA2019112506896Battery Pack · inoperativeL4 AND R4 DOOR EMERGENCY EXIT SIGNS ARE INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.
Back to JASC 3350