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 SWAA2017071715091Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM AND WDM.SDR DALA2017071305474Light · missingDURING SERVICE CHECK, FOUND EMERGENCY LIGHT 21D MISSING, FOUND LIGHT IN OVERHEAD BIN. REPLACED EMERGENCY LIGHT FIXTURE AT ROW 21D IAW CMM 25-21-52. OPS CHECKED GOOD.SDR SWAA2017071715026Cover · defectiveR2 DOOR EMERGENCY LIGHT COVER MISSING RED ARROW. R&R COVER PER MM.SDR SWAA2017071715025Cover · defectiveL2 DOOR EMERGENCY LIGHT COVER MISSING RED ARROW. R&R COVER PER MM.SDR SWAA2017071715024Cover · defectiveRT OVERWING EMERGENCY DOOR EXIT LIGHT COVER MISSING RED ARROW. R&R COVER PER MM.SDR DALA2017071305433Switch · faultyEMERGENCY LIGHTS STAY ON IN ARM POSITION. REPLACED EMERGENCY LIGHT COCKPIT SWITCH.SDR AALA201707149026Battery Pack · no testEMERGENCY LIGHTING INOPERATIVE: INTERIOR OVERWING LIGHTS AT ROW 20A/20F, CEILING LIGHTS ROWS 7 TO 17 AND ROW D BACK, SEAT LIGHTS 3E TO 20D, AND PATH LIGHTS 3/4 WAY DOWN THE CABIN. REMOVED AND REPLACED BATTERY PACKS AT B5-101, B5-102, B5-103, AB5-2 AND AB5-3 SDR AALA201707139040Battery Pack · no testEMERGENCY LIGHTING INOPERATIVE: INTERIOR OVERWING LIGHTS AT ROW 20A/20F, CEILING LIGHTS ROWS 7 TO 17 AND ROW D BACK, SEAT LIGHTS 3E TO 20D, AND LIGHTS 3/4 WAY DOWN THE CABIN. REMOVED AND REPLACED THE BATTERY PACKS AT B5-101, B5-102, B5-103, AB5-2 AND AB5-3 ISDR AALA201707139039Battery Pack · no testEMERGENCY LIGHTING INOPERATIVE: INTERIOR OVERWING LIGHTS AT ROW 20A/20F, CEILING LIGHTS ROWS 7 TO 17 AND ROW D BACK, SEAT LIGHTS 3E TO 20D, AND LIGHTS 3/4 WAY DOWN THE CABIN. REMOVED AND REPLACED THE BATTERY PACKS AT B5-101, B5-102, B5-103, AB5-2 AND AB5-3 ISDR AALA201707139038Battery · no testEMERGENCY LIGHTING INOPERATIVE: INTERIOR OVERWING LIGHTS AT ROW 20A/20F, CEILING LIGHTS ROWS 7 TO 17 AND ROW D BACK, SEAT LIGHTS 3E TO 20D, AND LIGHTS 3/4 WAY DOWN THE CABIN. REMOVED AND REPLACED THE BATTERY PACKS AT B5-101, B5-102, B5-103, AB5-2 AND AB5-3 ISDR AALA201707139037Battery · no testEMERGENCY LIGHTING INOPERATIVE: INTERIOR OVERWING LIGHTS AT ROW 20A/20F, CEILING LIGHTS ROWS 7 TO 17 AND ROW D BACK, SEAT LIGHTS 3E TO 20D, AND LIGHTS 3/4 WAY DOWN THE CABIN. REMOVED AND REPLACED THE BATTERY PACKS AT B5-101, B5-102, B5-103, AB5-2 AND AB5-3 ISDR AALA201707139035Sign · brokenEMERGENCY EXIT SIGN ON THE CEILING RIGHT SIDE AISLE FORWARD OF THE R2 DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-25-02 AND EA 271677. AIRCRAFT WAS GROUNDED.SDR AALA201707139033Light · looseFLOOR EMERGENCY LIGHT STRIP IS COMING LOOSE AROUND ROWS 11-12 RIGHT SIDE. SECURED THE LIGHT STRIP IAW AMM 33-51-15. OPS CHECKED GOOD.SDR AALA201707139030Sign · detachedEMERGENCY EXIT SIGN BY THE L2 DOOR BECAME DETACHED. SECURED EXIT SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR R61A201707120526Battery Pack · inoperativeCOCKPIT CEILING EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERY PACK NR 1 UNDER PANEL 228ARC IAW AMM 33-50-01. OPS TESTED GOOD.SDR IPXA2017071319245Control Panel · inoperativeEMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08-401.SDR AALA201707139032Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT SIGN PER 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201707139031Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R1 DOOR HAS A DETACHED LENS COVER. REATTACHED LENS COVER. OPERATIONAL CHECK GOOD.SDR SWAA2017071315007Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017071315006Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017071314979Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017071314977Light · inoperativeL/H OVERWING EMERGENCY EXIT LIGHT INOP AT ROW 15. R & R LIGHT ASSEMBLY IAW MM.SDR AALA201707139017Lens · missingL2 DOOR EXIT THRESHOLD LIGHT COVER MISSING. INSTALLED THE LENS.SDR AALA201707139016Lens · looseEMERGENCY LIGHT CAP ON SEAT 9D LOOSE. SECURED THE LENS CAP.SDR AALA201707139014Lens · missingL1 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED LENS IAW AMM.SDR AALA201707139011Lens · missingFLIGHT ATTENDANT STATED THE EXIT SIGN OFF THE R2 DOOR LOWER FOUND MISSING. REPLACED THE R2 DOOR EMERGENCY LIGHT LENS IAW AMM.SDR AALA201707139010Shroud · damaged26C EMERGENCY LIGHT SHROUD DAMAGED. REPLACED EMERGENCY LIGHT SHROUD AT 26C.SDR AALA201707139009Lens · detachedEXIT LIGHT LENS, LEFT SIDE CAME OFF. REINSTALLED EMERGENCY LIGHT LENS.SDR DALA2017071305389Lens · missingEMERGENCY LIGHT LENS MISSING. INSTALLED THE LIGHT LENS.SDR DALA2017071305388Cover · unsecureEMERGENCY EXIT LIGHT COVER UNSECURE AT ROW 1. INSTALLED THE LIGHT COVER.SDR MASA2017071212454Battery Pack · dischargedLOWER EMERGENCY EXIT LIGHTS INOP. R2 BATTERY PACK NR 5.SDR JJBA20170712018Inverter · inoperativeSERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE NR 2 EMERGENCY LIGHT INVERTER. OPS CHECKED GOOD.SDR SWAA2017072515245Light · crazedRIGHT EMERGENCY LIGHT STRIP FOUND CRAZED. R & R THE LIGHT STRIP IAW MT.SDR SWAA2017072515243Light · crazedLEFT EMERGENCY LIGHT STRIP CRAZED. R & R IAW MT.SDR AALA201707129031Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT LEFT HORIZONTAL AT THE G5 GALLEY HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE FLOOR PROXIMITY LIGHT PER DMC-B787-A-33-51-06. OPERATIONAL CHECK GOOD.SDR DALA2017071205427Bulb · inoperativeALL THREE EMERGENCY LIGHTS IN CREW REST ARE INOPERATIVE. REPLACED ALL THE BULBS, SYSTEM OPS NORMAL.SDR QXEA2017071400469Lens · looseLENS COVER ON TYPE II/ III EMERGENCY EXIT IAW LOOSE. REMOVED FROM SERVICE. SECURED THE LENS. AIRCRAFT RETURNED TO SERVICE.SDR AALA201707139027Battery · no testEMERGENCY EXIT LIGHT AT THE R1 DOOR EXTERIOR SLIDE IS INOPERATIVE. REMOVED AND REPLACED THE CHARGER ASSEMBLY AND BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201707129025Charger · no testEMERGENCY EXIT LIGHT AT THE R1 DOOR EXTERIOR SLIDE IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER ASSEMBLY AND BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201707129020Lens · detachedEMERGENCY EXIT LIGHT ON THE CEILING BY THE OVERWING EXIT HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201707129019Lens · detachedEMERGENCY EXIT SIGN LENS IN THE FORWARD GALLEY CAME OFF DURING TAKEOFF. SECURED THE LENS. OPERATIONAL CHECKED GOOD.SDR AALA20170711006Cover · crackedCRACKED EMERGENCY LIGHT COVER AT DOOR R1, NEAR FLOOR. REPLACED EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017071315009Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM AND DWG.SDR SWAA2017071315008Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017071314999Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017071314998Nut Plate · missingLEFT FORWARD EMERGENCY LIGHT BATTERY PACK POWER SUPPLY MISSING ONE NUT PLATE TO ATTACH BATTERY TO BASE. R & R THE POWER SUPPLY BASE IAW AMM.SDR SWAA2017071314988Battery Pack · no testRIGHT AFT EMERGENCY EXIT LIGHT FAILED THE CAPACITY CHECK AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR DALA2017071205402Battery Pack · inoperativeDURING INSPECTION, FOUND THE R2 DOOR EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2017071205401Battery Pack · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHTS AT ROW'S 77, 78, AND 79 ARE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY IAW WDM33-51-14, OP CHECKED NORMAL.SDR SIMA20170711004Bulb · inoperativeROW 7 AND 17 OVERHEAD EMERGENCY LIGHTS OUT. R & R THE BULBS IAW AMM 33-51-09. OPS CHECKED GOOD.
Back to JASC 3350