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 ASAA2019080763330Lens · detachedEXIT SIGN FELL OFF FROM ROW 17 DEF AREA. GROUNDED - YES. REINSTALLED "EXIT" LIGHT COVER AT 17 DEF.SDR ASAA2019080763325Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT R-2 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER B737-800 AMM 33-51-01-960-801 - OPS NORMAL.SDR AALA201908079010Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT RIGHT FLIGHT ATTANDANT REPORTED BRAKEAWAY FLASH LIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 33-51-00.SDR AALA201908079009Light · damagedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY PATHWAY LIGHT AT SEAT 4C WAS DAMAGED. MAINTENANCE REPLACED LIGHT PER AMM 33-51-19.SDR AALA201908079007Battery · no testAIRCRAFT WAS NOT GROUNDED: EPSU BATTERY FAILED AT L1 ENTRY DOOR. MAINTENANCE REPLACED EPSU BATTERY PER 33-51-38.SDR AALA201908079006Lens · missingAIRCRAFT WAS NOT GROUNDED: LAVATORY E HAD EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED LIGHT LENS PER STANDARD PRACTICES.SDR AALA201908079005Battery · no testAIRCRAFT WAS GROUNDED: DURING ACCOMPLISHMENT OF 25-94-03 ON R4 DOOR CIDS TEST SHOWED EPSU BATTERY EMERGENCY LEFT FAULT. MAINTENANCE REPLACED EPSU BATTERY PER AMM 33-51-00.SDR SWAA2019080735717Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. / R&R BATTERY PER AMM.SDR SWAA2019080735706Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. / R&R BATTERY PER AMM.SDR SWAA2019080735704Lamp · inoperativeL/H EMERGENCY AREA LIGHT INOP AT ROW 4. / R&R LAMP IAW AMM.SDR SWAA2019080635667Battery Pack · dischargedSUPPLEMENTAL INFORMATION, RT SIDE EMERGENCY LIGHT AT ROW 25 INOP. R&R BATTERY PACK PER AMM.SDR 2019FA0000244Battery Pack · weakEMERGENCY LIGHTING BATTERY PACK FAILED TEST UNKOWN HOURS ON BATTERY PACK.SDR I5EA2019083003Battery Pack · dischargedSECOND CABIN EMERGANCY LIGHT INOP. REMOVED AND REPLACED THE BATTERY PACK ON RIGHT OVERWING IAW AMM 33-51-51 TESTED OKAY IAW AMM 33-51-51.SDR AALA201908059025Lens · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 5A HAD BROKEN LENS. MAINTENANCE REPLACED LIGHT PER AMM 33-50-00.SDR R61A2019080950820Power Supply · faultyOVERHEAD EMERGENCY LIGHT, 2ND LIGHT BACK, NOT WORKING. R&R FWD EMERGENCY LIGHT POWER UNIT REF MM 33-50-01.SDR QXEA2019080800307Sign · detachedEMERGENCY EXIT SIGN FELL OFF THE EMERGENCY EXIT DOOR. REMOVED FROM SERVICE. RE-SECURED PLASTIC EMERGENCY EXIT SIGN COVER FOR THE TYPE II/III EMERGENCY EXIT. RETURNED TO SERVICE. NO PARTS REPLACED.SDR DALA2019080804657Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT SEAT 12J. REPLACED LIGHT ASSEMBLY AT SEAT 12J.SDR SWAA2019080835742Housing · looseCEILING AFT GALLEY EMERGENCY EXIT SIGN NOT SECURED. R&R SIGN HOUSING ASSEMBLY PER AMM.SDR AALA201908079001Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R4 EMERGENCY SLIDE LIGHT INOPERABLE. MAINTENANCE REPLACED SLIDE LIGHT IAW AMM 33-51-06.SDR SWAA2019080735713Battery Pack · no testFORWARD EMERGENCY LIGHTS POWER SUPPLY M1675 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019080735694Sign · detachedEMERGENCY EXIT SIGN MID CABIN AT OVERWING EXIT WAS KNOCKED DOWN. R&R SIGN PER AMM.SDR SWAA2019080735693Fuse · blownEMERGENCY EXIT SIGN MID CABIN AT OVERWING EXIT WAS KNOCKED DOWN. FOUND FUSE BLOWN ON BATTERY PACK M1668. R&R BATTERY PACK PER AMM.SDR AALA201908069016Lens · missingAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT ON SEATS 8C THROUGH 9D MISSING LENS COVER. MAINTENANCE REPLACED ESCAPE PATH SEAT MOUNTED LIGHTS PER AMM 33-51-16.SDR AALA201908069014Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING CARD 2324, FOUND EMERGENCY CEILING LIGHTS BETWEEN SEATS 17D AND 23D DID NOT REMAIN ILLUMINATED FOR THE REQUIRED 15 MINUTES. MAINTENANCE REPLACED AFT BATTERY PACK PER AMM 33-51-06.SDR AALA201908069011Lens · damagedAIRCRAFT WAS NOT GROUNDED: LENS COVER FOR EMERGENCY EXIT LIGHT IN FORWARD GALLEY DAMAGED. MAINTENANCE REPLACED LENS COVER PER STANDARD PRACTICES.SDR AALA201908069010Lens · unsecureAIRCRAFT WAS NOT GROUNDED: AFT GALLEY RIGHT SIDE EXIT COVER KEEPS FALLING OFF. MAINTENANCE REPLACED EXIT COVER PER MM 33-50-00.SDR DALA2019080604624Light · brokenSEAT 37F HAS PLASTIC EMERGENCY LIGHTS ASSEMBLY BROKEN AND HANGING AT BASE OF SEAT SEACURED SEAT 37F PLASTIC EMERGENCY LIGHTS ASSEMBLY AS REQUIRED. SYSTEM OPERATION IS NORMAL.SDR DALA2019080604623Power Supply · inoperativeEXTERIOR EMERGENCY LIGHTS ARE INOPERATIVE AT FUSELAGE AFT OF RIGHT WING AND R2 DOOR. REPLACED POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR DALA2019080604607Cids · malfunctionedEMERGENCY EXIT SIGNS INOPERATIVE. RESET CIDS, OPERATIONAL CHECK OK. LP 1206761SDR SWAA2019080635668Lens · detachedOVERWING CENTER AISLE EMERGENCY EXIT SIGN LENS FELL OFF. SECURED LENS IAW SIP.SDR SIMA201908065001Sign · inoperativeDURING PS-1 CHECK, FOUND OVERWING EMER EXIT LOCATING SIGN FWD INOP-C/A-REMOVED AND REPLACED OVERWING FWD EMER EXIT LOCATING SIGN IAW EMB140 AMM 33-50-15, OPS CHECK GOOD.SDR MASA2019080651986Bulb · inoperativeLHS OVER WING EXIT LWR SIGN-1 BULB INOPERATIVE.SDR VNAA2019080411102Housing · defective#5 CEILING EMERGENCY FLOOD LIGHT WILL NOT ILLUMINATE REMOVED AND REPLACED LAMP HOUSING OPS CHECK GOOD AT THIS TIME.SDR SIMA201908054003Light · inoperativeUPON PS-1 CHECK FOUND PASSENGER COMPARTMENT REAR FLOOR LIGHT STRIP INOPERATIVE. REMOVED AND REPLACED REAR FLOOR LIGHT STRIP IAW AMM 33-50-12. OPS CHECK FAILED, FOUND BAD CONNECTION AT CRIMP, BROKEN CRIMP. T/S THE REAR EMERGENCY LIGHT FLOOR STRIP, FOUND CONNSDR DALA2019080964686Power Supply · intermittentFOUND EMERGENCY LIGHT AT SEATS 43-45 INTERMITTENT. REMOVED AND REPLACED M736 EMERGENCY POWER SUPPLY. OPS CK NORMAL PER B757 AMM 33-51.SDR ASAA2019080430334Cover · detachedFORWARD CABIN ANNUNCIATION LIGHT COVER FELL OFF. GROUNDED - YES. REMOVED & REPLACED FWD OVERHEAD EXIT SIGN LIGHT ASSY AND INSTALLED REPLACEMENT FWD CABIN LIGHT COVER. OPS NORMAL IAW AMM 33-51-01 AND AMM 23-43-00.SDR YENA2019080804434Battery Pack · inoperativeFT # 1525, WITH ALL POWER OFF THE AC MANY OF THE EMERGENCY LIGHTS ARE NOT ILLUMINATED ON BATTERY POWER, TRIED WITH THE OVERHEAD SWITCHES AND THE FAP. R & R LH EPSU BATTERY AND EMERGENCY EXIT RT EMERGENCY LIGHT BATTERY EXIT ROW IAW AMM 33-51-00.SDR R61A201908040811Battery · faultyEMERGENCY LIGHT BATTERY FAULT ADVISORY MESSAGE DISPLAYED DURING EMERGENCY LIGHTS TEST. R&R RH FWD EMERGENCY LIGHT BATTERY IAW AMM 33-50-01.SDR SWAA2019080635685Light · unsecurePHOTO ILLUMINESCENT FLOOR LIGHT STRIP AT ROW 8 COMING UP. / SECURED STRIP PER AMM.SDR SWAA2019080635684Lens · dislodgedL/H SIDE EMERGENCY EXIT ROW PLASTIC SIGN COVER DISLODGED. / SECURED LENS ASSEMBLY PER SIP.SDR SWAA2019080635683Lens · brokenL1 LOWER EMERGENCY EXIT LIGHT LENS BROKEN. / R&R LIGHT INDICATION ASSEMBLY IAW MT.SDR DALA2019080604606Battery Pack · inoperativeCIDS 1 FAULTING EPSU BATTERY MID R, REPLACED EPSU BATTERY MID (14WL)SDR AALA201908059017Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS IN FOLLOWING POSITION ARE OUT OF COMPLIENCE. DOOR 1R, OVERWING LEFT (SEE AALA201908059013) AND RIGHT, OVERHEAD DOOR 2L, CEILING MOUNT BETWEEN AFT LAVATORIES. MAINTENANCE REPLACED LIGHTS AT DOOR 1R PER AMM 33-51-SDR AALA201908059016Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS IN FOLLOWING POSITION ARE OUT OF COMPLIENCE. DOOR 1R, OVERWING LEFT AND RIGHT, OVERHEAD DOOR 2L, CEILING MOUNT BETWEEN AFT LAVATORIES. MAINTENANCE REPLACED LIGHTS AT MOUNT PER AMM 33-51-16.SDR AALA201908059015Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS IN FOLLOWING POSITION ARE OUT OF COMPLIENCE. DOOR 1R, OVERWING LEFT AND RIGHT, OVERHEAD DOOR 2L, CEILING MOUNT BETWEEN AFT LAVATORIES. MAINTENANCE REPLACED LIGHTS AT OVERHEAD DOOR 2L PER AMM 33-51-16.SDR AALA201908059014Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS IN FOLLOWING POSITION ARE OUT OF COMPLIENCE. DOOR 1R, OVERWING LEFTAND RIGHT, OVERHEAD DOOR 2L, CEILING MOUNT BETWEEN AFT LAVATORIES. MAINTENANCE REPLACED LIGHTS AT OVERWING RIGHT SIDEWALL PER AMM 33-51-16.SDR AALA201908059013Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS IN FOLLOWING POSITION ARE OUT OF COMPLIENCE. DOOR 1R (SEE AALA201908059017), OVERWING LEFT AND RIGHT, OVERHEAD DOOR 2L, CEILING MOUNT BETWEEN AFT LAVATORIES. MAINTENANCE REPLACED LIGHTS AT OVERWING LEFT PER AMM SDR AALA201908059012Battery · no testAIRCRAFT WAS NOT GROUNDED: AISLE JUMPSEAT FLASHLIGHT WAS NOT CHARGING. MAINTENANCE REPLACED BATTERY PER AMM 25-60-00.SDR AALA201908059009Lens · detachedAIRCRAFT WAS NOT GROUNDED: CLEAR EMERGENCY EXIT LENS FELL OF DOOR 1R. MAINTENANCE REPLACED LENS PER AMM 33-51-01.SDR AALA2019080549001Light · dimAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN OVER R1 DOOR DIM. MAINTENANCE REPLACED LIGHT PER AMM 33-51-11.
Back to JASC 3350