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 YENA2018092100353Battery · dischargedFLT 225, JFK-TPA. EPSU BATTERY 11WL FAILS EMERGENCY LIGHT SYSTEM TEST. R&R EPSU 11WL BATTERY IAW AMM 33-51-38, SYSTEM OPS CHECKS GOOD.SDR AALA201809219031Power Supply · inoperativeRIGHT EMERGENCY LIGHTS, FORWARD CABIN SEATS 8H -21H WERE INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR IPXA2018092134216Bulb · inoperativeEMERGENCY LIGHT HAD FOUR INOPERATIVE BULBS. R & R THE BULBS IN THE EMERGENCY LIGHT IAW AMM 33-51-01-2.SDR DALA2018092105685Lens · brokenEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:EME / ACARS TEXT: FRC 335201. EMERGENCY TRACK LIGHT RED LENS COVER BROKEN / INTERIOR. INSTALLED LENS COVER.SDR MASA2018092011392Battery · dischargedEMER EXIT SIGN AFT OF 1ST CLASS INOP. ALLOWED BATTERIES TO CHARGE.SDR MASA2018092011391Battery · discharged6 CEILING LEVEL EMER FLOOD LIGHTS INOP. ALLOWED BATTERIES TO CHARGE.SDR DALA2018092005674Housing · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE AT SEAT 30D. REMOVED AND REPLACED LIGHT HOUSING IAW CMM 25-23-51 FIG 25. OPERATION CHECKS GOOD.SDR DALA2018092005670Battery · dischargedDURING SERVICE CHECK MAINTENANCE FOUND THE MID CABIN UPPER EMERGENCY LIGHTS ON THE LEFT & RIGHT TO BE INOPERATIVE. MAINTENANCE REPLACED THE INBOARD MID CABIN UPPER LEFT AND RIGHT EMERGENCY LIGHTS BATTERIES PER MD-88 AMM 33-55. OPERATION NOW CHECKS GOOD.SDR DALA2018092005669Battery · dischargedON SERVICE CHECK, FOUND CABIN EMERGENCY LIGHTS FROM ROW 1 TO 15 INOPERATIVE. MAINTENANCE REPLACED BATTERY POWER PACKS PER AMM 33-50. CHECK IS NOW NORMAL.SDR FDEA201809192588Lamp · inoperativePOST-FLT INSPECTION, R-1 DOOR OUTSIDE EMERGENCY LIGHT INOPERABLE. RE-LAMPED, REF B777 AMM: 33-51-04-2. EMERGENCY LIGHTS TEST SATISFACTORY, ITEM OK FOR SERVICE.SDR FDEA201809192587Lamp · inoperativePOST-FLT INSPECTION, R-1 DOOR OUTSIDE EMERGENCY LIGHT INOPERABLE RE-LAMPED, REF B777 AMM 33-51-04-2. EMERGENCY LIGHTS TEST SATISFACTORY, ITEM OK FOR SERVICE.SDR FDEA2018092692587Lamp · no testPOST-FLT INSP, R-1 DOOR OUTSIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM: 33-51-04-2. EMERGENCY LIGHTS TESTED SATISFACTORY, OK FOR SERVICE.SDR FDEA2020021092589Lamp · inoperativePOST-FLT INSP, R-1 DOOR OUTSIDE EMERGENCY LT INOP RE-LAMPED, REF B777 AMM: 33-51-04-2. EMERGENCY LT'S TEST SATIS, ITEM OK FOR SVC.SDR FDEA2020021092588Lamp · inoperativePOST-FLT INSP, R-1 DOOR OUTSIDE EMERGENCY LT INOP RE-LAMPED, REF B777 AMM: 33-51-04-2. EMERGENCY LT'S TEST SATIS, ITEM OK FOR SVC.SDR FDEA2020021092587Lamp · inoperativePOST-FLT INSP, R-1 DOOR OUTSIDE EMERGENCY LT INOP RE-LAMPED, REF B777 AMM: 33-51-04-2. EMERGENCY LT'S TEST SATIS, ITEM OK FOR SVC.SDR SIMA201811269004Bulb · inoperativeLH OVER WING EMERGENCY LIGHT IS INOP.-C/A-COMPLETE:REMOVED AND REPLACED L/H OVER WING EMERGENCY LIGHT BULB IAW EMB 145 AMM 33-50-10. OPC GOOD.SDR SWAA2018092525516Housing · damagedUPPER CENTER EMERGENCY EXIT LIGHT HOUSING DAMAGED AT OVERWING EXIT AREA. R&R LIGHT IAW AMM.SDR SWAA2018092425486Sign · looseEXIT SIGN LOOSE OVER BETWEEN ROWS 14 AND ROW 15. SECURED SIGN PER SIP.SDR SWAA2018092425459Strip · delaminatedRT FORWARD EGRESS STRIP DELAMINATED. R&R STRIP PER DWG.SDR SWAA2018092025411Light · crackedFORWARD LT EMERGENCY FLOOR TRACK LIGHTING STRIP CRACKED. R&R STRIP PER AMM.SDR SWAA2018092025410Charger · defectivePAX CABIN LIGHTING EMERGENCY CHARGER PACK POPPED, RESET, AND POPPED AGAIN AT LOCATION M1695. R&R BATTERY PACK CHARGER PER AMM.SDR SWAA2018092025409Battery Pack · dischargedL2 DOOR EMERGENCY EXIT SIGN LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018092025406Light · missingR1 DOOR LOWER EMERGENCY LIGHT MISSING BULB. INSTALLED BULB IAW AMM.SDR SWAA2018092025396Battery Pack · defectivePAX CABIN LIGHTING EMERGENCY CHARGER PACK POPPED, RESET, AND POPPED AGAIN AT LOCATION M1695. R&R BATTERY PACK PER AMM.SDR SWAA2018092025395Light · crackedFORWARD RT EMERGENCY FLOOR TRACK LIGHTING STRIP CRACKED. R&R STRIP PER AMM.SDR SWAA2018092025392Battery Pack · dischargedL2 DOOR EXTERIOR EMERGENCY EXIT SIGN LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018092025391Cover · missingLT EMERGENCY EXIT LIGHT COVER MISSING AT ROW 23. R&R COVER PER MM.SDR AALA201809259004Battery Pack · inoperativeEMERGENCY EXIT OVERHEAD AILSE LIGHT WAS INOPERATIVE ABOVE SEAT ROWS 18 ABC AND 21 ABC. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1670, OPS CHECKED NORMAL IAW AMM 33-51-06.SDR DALA2018092505736Power Supply · inoperativeTHE FORWARD EMERGENCY PATH LIGHTS WERE FOUND TO BE INOPERATIVE DURING A SERVICE CHECK. MAINTENANCE FOUND THE POWER SUPPLY AND BATTERY TO BE BAD. THE POWER SUPPLY AND BATTERY WERE REPLACED PER AMM 33-53. OPERATIONAL CHECK WAS GOOD.SDR ASAA2018092426225Light · inoperativeAFT LAMP BURNED OUT IN LT FWD OVERWING EXIT SIGN. GROUNDED - YES. RELAMPED, OPS TEST GOOD REF AMM 33-51-01.SDR AALA2018092419007Lens · missingEMERGENCY LIGHT RED LENS AT ROW 9 RT WAS MISSING. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-15-0401.SDR AALA201809219029Lamp · inoperativeEMERGENCY EXIT LIGHT AT THE R3 DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE LAMP IAW AMM 33-50-00-970-001, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018092005697Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:02R / ACARS TEXT: FRC33510202R / INTERIOR. SECURED COVER.SDR AALA2018092109035Battery · faultedPERFORMED A BATTERY CHECK FOR R3 SLIDE REPLACEMENT, FOUND THE BATTERY 14WL TO BE FAULTING. REPLACED THE EMERGENCY LIGHT BATTERY IAW AMM 33-51-35. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA2018092109030Battery · faultedPERFORMED A BATTERY CHECK FOR R3 SLIDE REPLACEMENT, FOUND THE BATTERY 10WL TO BE FAULTING. REPLACED THE BATTERY IAW AMM 33-51-35. OPS CHECKED GOOD, OK FOR SERVICE.SDR AALA2018092109022Bulb · burned outLEFT OVERWING EXIT LIGHT SIGN HAD 5 OF 14 BULBS INOPEATIVE. REPLACED THE BULBS IAW AMM 33-51-11.SDR AALA2018092109021Bulb · burned outCEILING MID CABIN FORWARD FACING EMERGENCY EXIT SIGN HAD 4 OF 14 BULBS INIOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-11.SDR HALA2018091900221Light · malfunctionedEMERGENCY LIGHTS COME ON IN FLIGHT AND WON'T RESET. RESET POWER.SDR FDEA2018092092589Light · inoperativePOST FLT INSP, R1 DOOR OUTSIDE EMERGENCY LIGHT INOP. RE-LAMPED, REF AMM 33-51-04-2. EMERGENCY LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR FDEA2018092092588Light · inoperativePOST FLT INSP, R1 DOOR OUTSIDE EMERGENCY LIGHT INOP. RE-LAMPED, REF AMM 33-51-04-2. EMERGENCY LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR FDEA2018092092587Light · inoperativePOST FLT INSP, R1 DOOR OUTSIDE EMERGENCY LIGHT INOP. RE-LAMPED, REF AMM 33-51-04-2. EMERGENCY LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR SIMA2018092019001Light · inoperativeMAIN DOOR FAIRING EMERGENCY LIGHT INOP. REMOVED AND REPLACED MAIN DOOR LINING PANEL IAW AMM TASK 25-23-04. OPS CHECK GOOD.SDR AALA201809209020Lens · detachedR1 DOOR EMERGENCY LIGHT LENS DETACHED. REPLACED THE EMERGENCY LIGHT LENS. CHECKED OK.SDR AALA201809209019Bulb · burned outL1 DOOR EMERGENCY EXIT SIGN HAD 4 OF 14 BULBS INOPERATIVE . REPLACED THE BULBS IAW AMM 33-51-11.SDR AALA201809209018Bulb · burned outEMERGENCY EXIT SIGN MAIN CABIN MID CEILING AFT FACING NEEDS 11 OF 14 BULBS. REPLACED THE BULBS IAW AMM 33-51-11.SDR AALA201809209037Bulb · inoperativeEMERGENCY EXIT SIGN, AFT CABIN CEILING, FORWARD FACING, NEEDS 7 OF 14 BULBS REPLACED. REPLACED THE BULBS IAW AMM 33-51-11.SDR DALA2018092005684Light · inoperativeEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP. REMOVED AND REPLACED EMERGENCY SEAT MOUNTED LIGHT AT 36D IAW AMM OPS CHECK GOOD. A/C OK FOR SERVICE. 'M' PROCEDURES REVERSED.SDR DALA2018092005679Light · damagedEMERGENCY ESCAPE PATH LIGHT AT 1ST CLASS GALLEY LOWER WALL DAMAGED. REPLACED EMERGENCY ESCAPE PATH LIGHT ASSY AT 1ST CLASS GALLEY LOWER WALL, OPS CK NML.SDR YENA2018092090352Battery · dischargedFLT 2680, EWR-BOS. 2 EACH EMERGENCY LIGHT POWER UNITS FAILED OPERATIONAL TEST. REPLACED 2 EACH EMERGENCY POWER UNITS IAW AMM 33-50-01.SDR YENA2018092090351Battery · dischargedFLT 2680, EWR-BOS. 2 EACH EMERGENCY LIGHT POWER UNITS FAILED OPERATIONAL TEST. REPLACED 2 EACH EMERGENCY POWER UNITS IAW AMM 33-50-01.
Back to JASC 3350