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 DALA2017051403878Cover · missingROW 11 RIGHT EMERGENCY LIGHT COVER MISSING, REPLACED THE COVER.SDR AALA201705169064Lens · brokenEMERGENCY LIGHT LEFT SIDE G5 GALLEY HAS A BROKEN LENS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-15-06. OPERATIONAL CHECK GOOD.SDR AALA201705169063Lens · brokenEMERGENCY LIGHT RIGHT SIDE FIRST CLASS GALLEY HAS A BROKEN LENS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-06. OPS CHECKED GOOD.SDR IPXA2017051217036Lamp · inoperativeSEVERAL EMERGENCY EXIT SIGN LAMPS INOPERATIVE. REPLACED THE LAMPS AS NEEDED, TESTED NORMAL IAW AMM 33-51-01-962-001.SDR SWAA2017051713793Battery Pack · dischargedCENTER AISLE EMERGENCY EXIT SIGN L1070 INOP. R&R BATTERY PACK PER MM.SDR SWAA2017051713762Power Supply · inoperativeCENTER AISLE EMERGENCY EXIT SIGN L1070 INOPERATIVE. R & R THE POWER SUPPLY IAW MM.SDR SWAA2017051613757Cover · looseAFT GALLEY EMERGENCY EXIT SIGN LIGHT COVER LOOSE. SECURED THE COVER IAW AMM.SDR SWAA2017051713756Cover · looseLEFT EMERGENCY EXIT SIGN COVER LOOSE. SECURED THE SIGN COVER IAW SIP.SDR SWAA2017051713740Cover · looseFORWARD ENTRY EXIT LIGHT COVER LOOSE. R & R THE COVER IAW AMM.SDR AALA201705179007Lens · missingROW 9 RIGHT RED AND WHITE EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705169032Lens · missingEMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201705169029Lens · detachedEMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A DETACHED LENS. ATTACHED THE LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201705169018Lens · missingEMERGENCY EXIT LIGHT BY THE R4 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20170514003Light · no testSEAT MOUNTED FLOOR EMERGENCY LIGHTS AT SEAT 5H INOPERATIVE. REMOVED AND REPLACED PROXIMITY LIGHT IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR SWAA2017051613783Sign · damagedMID CABIN OVERHEAD EXIT LIGHT SIGN DAMAGED. R&R SIGN PER MM.SDR AALA201705169008Lens · brokenEMERGENCY LIGHT LENS BROKEN AT LAVATORY L. REPLACED THE LIGHT ASSEMBLY IAW MM 33-51-00.SDR AALA201705139005Lens · brokenEMERGENCY LIGHT LENS BROKEN AT LAVATORY D. REPLACED THE LIGHT ASSEMBLY IAW MM 33-51-00.SDR SIMA20170512002Charger · inoperativeDISCOVERED EMERGENCY AISLE LIGHTS ON ROWS 3-6, DO NOT OPERATE. REMOVED AND REPLACED BATTERY POWER SUPPLY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD.SDR AALA201705159023Lens · unsecureAIRCRAFT NOT GROUNDED. EMERGENCY LT COVER AT 1R DOOR FELL OFF. INSTALLED NEW EMERGENCY LT COVER ASSY R1 DOOR.SDR AALA201705159022Lens · missingAIRCRAFT NOT GROUNDED. R4 EMERGENCY EXIT LIGHT LENS MISSING. REPLACED R4 EMERGENCY EXIT LIGHT LENS.SDR AALA201705159017Lens · missingAIRCRAFT NOT GROUNDED. ROW 3 LEFT EMER LENS MISSING. INSTALLED EMER LENS AT ROW 3 LEFT.SDR DALA2017051303880Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS.SDR UIEA2017051500787Lamp · inoperativeRIGHT UPPER CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-05.SDR DALA2017051503868Cover · looseEMERGENCY EXIT SIGN COVER LOOSE, LOCATION 604. ADJUSTED EXIT SIGN, OK FOR SVC.SDR MASA2017051212296Light · inoperativeMID CABIN OVERHEAD EMER LIGHT INOP. REPLACED BULB.SDR CALA2017051201413Light · inoperativeDOOR 1R EXTERIOR EMERGENCY LIGHT INOP. RELAMPED DOOR 1R EXTERIOR EMERGENCY LIGHT REF AMM-33-51-04. OPS CHECK GOOD AT THIS TIME.SDR CALA2017051201412Cover · brokenEMERG LIGHT COVER 2R UNDER 403 AFT GALLEY BROKEN OFF. REPLACED LIGHT ASSY AND COVER REF AMM 33-51-01. OPS CHECK GOOD.SDR CALA2017051201410Cover · missingEMER EXIT SIGN COVER AT ROW 21-DEF MISSING. REPLACED LIGHT COVER PER MM 33-51-01-960-802. OPERATION CHECKED GOOD ACFT OK TO CONTINUE.SDR CALA2017051201408Light · inoperativeDURING 2 SVC FOUND RT AFT OVERWING EMERGENCY LIGHT INOP. RELAMPED RT AFT OVERWING EMERGENCY LIGHT. OPS CHECK GOOD.SDR CALA2017051201407Light · inoperativeDURING 2 SVC FOUND RT AFT DOOR EMERGENCY LIGHT INOP. RELAMPED RT AFT DOOR EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2017051201404Lens · brokenRED EMERGENCY EXIT LIGHT LENS BROKEN ROW 20ABC. R&R LENS. OK TO CONTINUE IN SERVICE.SDR CALA2017051201403Lens · brokenWHITE EMERGENCY EXIT LIGHT LENS BROKEN ROW 15ABC. R&R LENS. OK TO CONTINUE IN SERVICE.SDR CALA2017051201402Cover · missingEMERG EXIT SIGN MISSING LITTLE ONE DOWN LOW. INSTALLED MISSING COVER AND OPS CKS OK.SDR CALA2017051201401Battery Pack · dischargedROW 22-30 EMERGENCY LIGHTS OUT. R&R BATTERY PACK REF AMM 33-51-06. OPS CHECK GOOD VERIFIED BATTERY PACK INSTALLATION REF 33-51-06.SDR CALA2017051201399Lens · looseFIRST CLASS EMERGENCY EXIT LENS LITE LOOSE. REINSTALLED AND SECURED LENS, OPS CHECK NORMAL.SDR CALA2017051201398Light · inoperativeEXTERIOR EMERGENCY SLIDE LIGHT BEHIND LEFT WING INOP. REPLACED LAMP IAW AMM 33-51-04. OPS CHK NORMAL. OK TO CONTINUE.SDR CALA2017051201383Power Supply · faultyR4 DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR CALA2017051201380Battery · faultyAFTER EPSU BITE TEST, THERE IS A EPSU BATTERY FWD L FAULT (10WL) AND EPSU BATTERY EMER L FAULT (11WL). REMOVE AND REPLACED EPSU BATTERY FWD L (10WL) AND EPSU BATTERY EMERGENCY (11WL) IAW- AMM-33-51-38-000 -002-A /33-51-38-400-002-A. PERFORMED OPS TEST REF AMM-SDR CALA2017051201379Light · inoperativeCABIN EMERGENCY LIGHTS CHECK FAULTS 33-51-38 EPSU EXT LOAD EMER R. FOUND RT AFT EXTERIOR OVERWING EXIT LIGHT WITH ONE BULB BURNED OUT. RELAMPED AND OPS CHECKED EMERGENCY LIGHTS REF AMM 33-51-00-7 10-001-A. ALL LIGHT CHECK GOOD.SDR CALA2017051201378Light · malfunctionedWITH A/C POWER OFF AND EMERGENCY LIGHT SWITCH SET TO ON, MULTIPLE EMERGENCY EXIT LIGHTS INOPERATIVE. PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTINGS, FAULT SHOWN FOR LT FWD EMERGENCY POWER SUPPLY UNIT. RESET BREAKER AND PERFORMED OPERATIONAL TEST OF EMERGENCSDR CALA2017051201377Power Supply · inoperativeWITH EMER LIGHTS ARMED AND A/C PWR TURNED OFF, ONLY CENTER CABIN EMER LIGHTS TURN ON. EMER LIGHTS TEST FROM PTP TESTED OK. REPLACED POWER SUPPLY UNIT AT AFT POSITION DUE UNIT FAILED INDICATION, REF AMM 33-51-38-400-001-A. REPLACED BATTERIES AT AFT, MID RIGHT ASDR CALA2017051201374Battery · faultyCABIN EEL LIGHTS SYSTEM CHECK - MAINTENANCE MESSAGE EPSU BATT FWD L, EPSU BATT EM RT. REPLACED EEL LIGHTS BATTS REF AMM 33-51-38. OPS CHECK GOODSDR CALA2017051201397Light · inoperativeOVER WING EMERGENCY PATH LIGHT INOP. RELAMPED LIGHT PER AMM TASK 33-51-04-960-801. TEST GOOD.SDR CALA2017051201394Cover · looseEMERGENCY EXIT SIGN OVER DOOR 2L IS NOT ATTACHED. 2L EXIT SIGN PLASTIC COVER REFITTED NOW OK.SDR CALA2017051201391Light · shortedAFTER TESTING EMER LIGHTS BETWEEN 31-34, NO LIGHTS SEE PREVIOUS WU CONFIRMED. FOUND SHORTED EMERGENCY LIGHT SEAT PATH LIGHT ASSY ON SEAT 31D. R&R IAW AMM 33-51-10-962-104. VISUAL OPS CHECK OF SYSTEM OK, TEST OF SYSTEM OK, A/C OK TO CONTINUE.SDR CALA2017051201390Battery Pack · not seatedSEAT MOUNTED EMER. LIGHTS PATH FROM ROW 31 TO 34 NOT WORKING. PERFORMED BATTERY PACK REMOVED AND REINSTALLED AS AMM 33-51-07/201, TEST OK.SDR CALA2017051201389Lens · missingMID GALLEY EMERGENCY LIGHT LENS COVER IS MISSING. REATTACHED MID GALLEY EXIT LIGHT LENS.SDR CALA2017051201387Light · inoperativeOPERATIONAL TEST FOUND SEAT 16AB AFT AND STAIR AREA EMERGENCY LT INOP. REPLACED THE CABIN SEAT 16AB AFT & STAIR AREA ONE EMERGENCY LT AND OPERATION TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-12-422-006 REV87 & AMM 33-51-12-712-009 REV87.SDR CALA2017051201386Light · inoperativePER M2 CHK FOUND EMERGENCY POWER OFF INDICATOR LIGHT 2EA INOP. RELAMPS OK.SDR CALA2017051201385Light · looseEMERG PATH LIGHT LOOSE NEAR 53C SEC'D THE LIGHT, OKAY TO CONTINUE.
Back to JASC 3350