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 AALA20170212004Power Supply · failedCABIN L1 DOOR FORWARD EMERGENCY LIGHT POWER SUPPLY (PACK) M33093 FAILED DEEP CYCLE CHECK. REPLACED POWER SUPPLY (PACK) M33093 PER AMM 33-51-06.SDR AALA20170212003Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR R3 OVERHEAD PANEL EMERGENCY POWER SUPPLY (PACK) M33404 FAILED LOADING, EMERGENCY LIGHTS DO NOT COME ON AND CANNOT RECHARGE BATTERY. REPLACED POWER SUPPLY (PACK) M33404 PER AMM 33-51-06.SDR AALA20170212002Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. DOOR L4 OVERHEAD PANEL EMERGENCY POWER SUPPLY (PACK) M33407 FAILED LOADING, EMERGENCY LIGHTS DO NOT COME ON AND CANNOT RECHARGE BATTERY. REPLACE POWER SUPPLY (PACK) M33407 PER 33-51-06.SDR AALA20170212001Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. CABIN R4 DOOR FORWARD LIGHT POWER SUPPLY (PACK) M33408 FAILED DEEP CYCLE CHECK. REPLACED POWER SUPPLY M33408 PER 33-51-06.SDR CALA2017021000300Battery Pack · dischargedBATTERY PACK DISCHARGED. THE BATTERY PACK WAS REPLACED AND TEST NORMAL IAW AMM 33-51-00.SDR CALA2017021000299Charger · inoperativeBATTERY CHARGER DISCHARGED. THE BATTERY CHARGER WAS REPLACED AND TEST NORMAL IAW AMM 33-51-00.SDR CALA2017021000298Battery Pack · dischargedBATTERY PACK FOUND DISCHARGED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2017021000297Battery Pack · dischargedBATTERY PACK DISCHARGED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2017021000296Battery Pack · dischargedBATTEY PACK DISCHARGED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2017021000295Charger · inoperativeM33400 BATTERY PACK CHARGER INOPERATIVE. THE CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2017021000294Battery Pack · dischargedBATTERY PACK M33400 DISCHARGED. BATTERY PACK REPLACED AND TESTED NORMAL IAW AMM 33-51-00SDR AALA20170208014Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT ON SEAT 20D IS INPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR DALA2017020801113Light · inoperativeREAR HALF OF OVERHEAD CEILING EXIT LIGHT IN THE CENTER OF THE AIRCRAFT IS INOP. REPLACED LED LIGHT ASSY.SDR DALA2017020801109Power Supply · inoperativeL2 DOOR EMERGENCY LIGHT INOP. REPLACED M733 POWER SUPPLY AND BATTERY IAW AMM 33-51.SDR DALA2017020801108Light · brokenSEAT 45 DEF EMERGENCY LIGHT BROKEN OFF OF THE SEAT. REATTACHED BROKEN TRIM/HOLDER. OK FOR SVC.SDR U2RA201702060001Charger · inoperativeR3 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER IAW AMM 33-51-07. OPS CHECKED GOOD.SDR SWAA2017020811750Light · inoperativeL1 DOOR AFT EXTERNAL EMERGENCY EXIT LIGHT INOP. R&R BULB PER AMM.SDR SWAA2017020811747Sign · missingR2 DOOR EMERGENCY EXIT SIGN MISSING. R&R SIGN PER AMM.SDR SWAA2017020811745Light · inoperativeLT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2017020801064Sign · unsecureDURING INSPECTION EMERGENCY EXIT SIGN FOUND IN CABIN. MAINTENANCE RESECURED SIGN. OPS CHECKS GOOD.SDR AALA20170208008Battery · faultyAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY EXIT LIGHT ABOVE SEAT 28D ILLUMINATES WHEN AIRCRAFT POWER IS OFF. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170208005Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE SEAT 21HJ IS DETACHED. REINSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017020801058Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED SEAT 55D. THE LENS WAS REPLACED. OPS CHECKED NORMAL IAW CMM 25-27-89.SDR DALA2017020801056Cover · missingEMERGENCY LIGHTS AT SEATS 3C AND 1B MISSING COVERS. REPLACED THE COVERS.SDR AALA201702089001Battery · dischargedEPSU 10WL HAS A FAILED BATTERY. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201702079009Lens · brokenEXIT LIGHT LENS BROKEN AT R4 DOOR. REPLACED THE LENS.SDR AALA201702079008Cover · missingEMERGENCY EXIT LIGHT COVER MISSING AT THE R4 DOOR. THE COVER WAS REPLACED.SDR DALA2017020701029Powerpack · not reportedREPLACED EMERGENCY LIGHT POWER PACKS AT STA 284LT 1356RT, 2R ATT SEAT AND STA M738,1340LT, M739 1362LT. SYSTEM OPERATION IS NORMAL.SDR DALA2017020701028Sign · inoperativeCOCKPIT EXIT SIGN DOES NOT ILLUMINATED WITH EMERGENCY LIGHT SWITCH SET TO ON, AND BATTERIES. SYSTEM OPERATION IS NORMAL.SDR ASOA201702064003Light · malfunctionedIAH - THE CREW REPORTED THAT THE GALLEY EMERGENCY LIGHT ABOVE THE SERVICE DOOR WAS NOT HOLDING A CHARGE. MAINTENANCE RESET THE EMERGENCY LIGHT SYSTEM, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017020701025Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. EMERGENCY EXIT SIGN MISSING BETWEEN JUMPSEAT 110 AND 111. RESECURED EMERGENCY EXIT LENS ABOVE J/S 111 AS REQUIRED.SDR JJBA20170206004Light · inoperativeROW 18CD EMERGENCY LIGHT INOPERATIVE. CYCLED CIRCUIT BREAKER, RESEATED PANEL. OPS CHECKED SAT.SDR CALA2017020600292Battery · dischargedEMERGENCY LIGHTS TEST FAILED AT PTP PANEL. REPLACED BATTERY AT EPSU 10WL REF AMM 33-51-38 PB401, NOW OK FOR SERVICE.SDR CALA2017020600291Power Supply · faultyPER 2SVC EMERGENCY LITE TEST FAIL ON CIDS PANEL. HAVE EPSU INT LOAD EMER L MSG. RPLD LT OW POWER SUPPLY, TEST PASS.SDR CALA2017020600290Battery · dischargedEPSU UNIT FWD L MESSAGE DISPLAYED AT CONCLUSION OF EMERGENCY LIGHT TEST. REPLACED EPSU BATTERY REF AMM33-51-38 OPS CHECKED GOOD.SDR CALA2017020600289Lens · missingEMERGENCY EXIT LIGHT ON PAX SEAT 8C END BAY PANEL LENS IS MISSING AND THE LIGHT IS PUSH INTO END BAY. REPLACED LIGHT ASSEMBLY ON PAX SEAT AISLE ENDBAY PANEL REF AMM 33-51-11-960-802, OPS TEST GOOD.SDR CALA2017020600288Battery Pack · discharged2SVC FOUND RT INTERIOR OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT POWER PACK M1695, OPS CK NORMAL ACP'D NON-RII INSP OF EMERGENCY LIGHTS REF GMM 9-10-05SDR CALA2017020600287Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT IS INOP AT SEAT 23C. REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSY AT SEAT 23C. OPS NORMAL. VERIFIED INSTALLATION AND OPSSDR CALA2017020600285Light · inoperativeL4 DOOR OUTSIDE EMERGENCY LIGHT INOP REF SPEC B777-33-3-6019. REPLACED THE L4 DOOR OUTSIDE EMERGENCY LIGHT BULB AND C/O EMER LT OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00-710-801 REV 78SDR CALA2017020600284Light · crackedDOOR NR1 CTR BAR DESK 1EA EMERGENCY LIGHT FOUND CRACK P/N:S479W230-6 SPEC B777-33-3-6019. REPLACED DR NR 1 CTR BAR DESK EMERGENCY LIGHT ASSY AND C/O EMER LIGHT OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00-710-801 REV 78.SDR CALA2017020600283Light · brokenSEAT 19DG FWD PARTITION LT & RT EMERGENCY LT FOUND BROKEN P/N: S479W230-6 SPEC B777-33-3-6019. REPLACED THE SEAT 19DG FWD PARTITION LT & RT EMERGENCY LT ASSY AND C/O EMER LT OPERATION TEST FOUND "NORMAL" REF AMM 33-55-00-7 10-801 REV 78.SDR CALA2017020600282Light · inoperativeSEAT 2H EMERGENCY LT INOP, SPEC B777-33-3-6 019. REPLACED THE SEAT 2H EMERGENCY LT ASSY AND C/O EMER LIGHT OPERATION TEST FOUND "NORMAL" REF AMM 33-51-00-710-801 REV 78.SDR CALA2017020600280Battery Pack · dischargedLT EMERGENCY LIGHT INOP R22 AFT. R&R BATTERY PACK AT M1670 PER AMM 33-51-960-804, LIGHTS NOW OP GOOD, ALL EMERGENCY LIGHT CK GOODSDR DALA2017020601002Charger · failedEMERGENCY LIGHT CHECK FOUND HATCH FLOOR LIGHTS L2-834, L2-835, L2-836, L2-837 INOPERATIVE. TROUBLESHOT IAW WDM 33-51-14 SHEET 1 AND SHEET 2. FOUND BLOWN FUSE AT B5-211, P1791 11. REPLACED THE FUSE, BLEW AGAIN, R & R THE BATTERY CHARGER ASSY B5-211 IAW AMM 33-5SDR MASA2017020612586Lamp · out of positionROW 4 EMERGENCY SIGN AFT SIDE INOPERATIVE. REPOSITIONED THE LAMP.SDR SWAA2017022212019Lens · brokenAFT GALLEY AREA EMERGENCY EXIT LENS BROKEN. R&R LENS IAW AMM.SDR RAIA201702050001Light · not seatedPAX DOOR EMERGENCY LIGHT IS INOPERATIVE. RESEATED THE LIGHT, OPS CHECKED GOOD.SDR AALA20170207015Light · damagedAIRCRAFT WAS NOT GROUNDED. ESCAPE PATH PROXIMITY LIGHT AT THE G2 GALLEY IS DAMAGED. REMOVED AND REPLACED THE FLOODLIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170206002Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AFT OF L4 DOOR IS MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR HNAA2017020800047Bulb · inoperativeEMERGENCY LIGHT AT 3DF IS INOPERATIVE. REMOVED AND REPLACED THE BULB.
Back to JASC 3350