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 CALA2017092403317Cids · intermittentEMERGENCY LIGHTS ILLUMINATE WITH THE SWITCH ARMED. EMERGENCY LIGHTS GO OUT AFTER RECYCLING TO OFF THEN ARMED. RESET CID SYS, ALL LIGHTS CHECKED NORMAL IAW 33-23-00SDR CALA2017092403314Light · brokenEMERGENCY LIGHT AND COVER BROKEN OFF SEAT AT 43D. REPLACED EMERGENCY LIGHT ASSEMBLY AT 43D PER MM 33-51-00 OPS CHK OK.SDR CALA2017092403316Light · inoperativeAFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED. OPS CHECK GOOD.SDR UIEA2017092601873Battery Pack · no testLEFT UPPER DECK EMERGENCY EXIT POWER SUPPLY BATTERY PACK FAILED A VOLTAGE CHECK. REMOVED AND REPLACED THE BATTERY PACK AND OPS CHECKED GOOD IAW AMM 52-23-14-001 AND AMM 52-23-14-404-005.SDR AALA201709279042Light · crackedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY ESCAPE FLOOR PROXIMITY LIGHT AT THE LEFT CORNER OF THE FORWARD GALLEY BY THE L1 DOOR IS CRACKED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709269003Control Unit · malfunctionedAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERTS RECEIVED FOR DOORS 2 AND 3 LEFT MID SEAT AND DOOR 3 LEFT AFT SEAT REMOTE WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT CONFIGURATIONS DO NOT AGREE WITH OTHER CONTROL UNITS. RAN FULL GROUND TEST OF ESDR AALA20170923003Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ABOVE THE R2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170924005Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. FORWARD GALLEY BIDIRECTIONAL ARROW EMERGENCY EXIT IDENTIFIER SIGN / LIGHT INOPERATIONAL. REMOVED AND REPLACED THE FORWARD GALLEY BIDIRECTIONAL ARROW EMERGENCY EXIT IDENTIFIER SIGN /LIGHT IAW AMM REF 33-51-10.SDR SWAA2017092616620Sign · missingOVERWING EMERGENCY EXIT SIGN COVER MISSING. R&R SIGN IAW AMM.SDR SWAA2017092616616Lens · unsecureFORWARD ENTRY EMERGENCY LIGHT LENS FELL OFF. INSTALLED LENS PER MM.SDR AALA201709269016Light · detachedL1 DOOR AFT LOWER EMERGENCY LIGHT, LOWER ASSEMBLY DETACHED FROM SIDEWALL. REPLACED THE LIGHT IAW AMM 35-51-13.SDR AALA201709269011Lamp · inoperativeR1 DOOR, FORWARD LOWER EMERGENCY EXIT LIGHT MARKER, LOWER LAMP IS INOPERATIVE AND LOWER PART OF LIGHT ASSEMBLY IS DETACHED FROM SIDE WALL. REPLACED THE EMERGENCY LIGHT AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201709259022Lens · missingESCAPE LIGHT LENS MISSING AT SEAT 8C. INSTALLED THE EMERGENCY LIGHT LENS IAW AMM.SDR AALA201709259017Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM.SDR AALA201709259016Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REPLACED THE LENS, OK FOR SERVICE.SDR AALA201709259015Lens · brokenR1 DOOR EXIT EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED THE LENS.SDR AALA201709259014Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW AMM.SDR AALA201709259004Battery · failedEMERGENCY POWER SUPPLY UNIT 17WL BATTERY FAILED. REMOVED AND REPLACED THE BATTERY IAW AMM.SDR YENA201709230789Power Supply · failedTHE LEFT AFT EMERGENCY LIGHT ON THE EXTERIOR WING TO BODY FAIRING FOUND INOPERATIVE. R & R EMERGENCY LIGHT POWER SUPPLY NR 6 IAW MM 33-50-01. OPS CHECKED GOOD.SDR DALA2017092507085Battery · dischargedOVERWING EXIT SIGN LIGHTS OVER FWD DOORS INOP. R&R BATTERIES IAW AMM 33-53-00.SDR REXA2017092301030Light · inoperativeLIGHT BULB(S) INOP FORWARD EMERGENCY EXIT SIGN. RELAMPED AS REQUIRED, REF AMM 33-51-11. NO FURTHER MX IS NECESSARY.SDR SWAA2017092516555Battery · dischargedL2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR AALA201709259013Lens · damagedAIRCRAFT WAS NOT GROUNDED. 3L DOOR EMERGENCY EXIT SIGN FELL OFF. REATTACHED EMERGENCY EXIT LENS COVER AT 3L DOOR.SDR DALA2017092507062Battery Pack · dischargedTHREE EMERGENCY LIGHTS INOPERATIVE. FOUND THE BATTERY DISCHARGED IN AFT RT LAVATORY. REPLACED THE BATTERIES IAW MM 33-53. EMERGENCY LIGHTS CHECKED OK.SDR DALA2017092407044Light · inoperativeLOWER EMERG EXIT SIGN NEXT TO AFT F/A JUMP SEAT HAS 2 BULBS OUT. RELAMPED, OPS GOOD.SDR CALA2017092303309Lens · brokenEMERGENCY EXIT SIGN DOES NOT TURN OFF LIGHT COVER BROKEN 1L. RELAMPED AND REPLACED LENS COVER AT FWD FLIGHT ATTENDANT FLOOR LIGHTING.SDR CALA2017092303308Lens · detachedEXIT SIGN BY DOOR 1R PLASTIC COVER FOUND ON GROUND BY CATERING. RE-INSTALLED LENS COVER. EMER LIGHTS CHK NORMAL IN ALL POSITIONS.SDR MASA2017092312657Light · inoperativeCEILING FLOOD LIGHT ROW 15 AND 18 INOP. MX REPLACED THE LIGHTS.SDR MASA2017092312653Battery · dischargedROW 12 AND 13 FLOOR LEVEL EXIT SIGNS INOP. ALLOWED BATTERIES TO CHARGE.SDR AALA201709279041Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY EXIT SIGN BY THE R3 DOOR IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AT THE R3 DOOR PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709279040Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY EXIT SIGN BY THE R2 DOOR IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AT THE R2 DOOR PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709279039Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY EXIT SIGN BY THE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AT THE L2 DOOR PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709259035Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L1 DOOR IS DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709259034Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT AT STATION 727 HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA201709259033Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A DETACHED LENS COVER. REFITTED LENS COVER PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201709259031Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE FORWARD GALLEY IS BROKEN. REMOVED AND REPLACED EXIT SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017092616645Lens · missingLT EMERGENCY BULLNOSE LIGHT LENS MISSING AT ROW 9. INSTALLED LENS PER SIP.SDR SWAA2017092616635Lens · missingLT EMERGENCY BULL NOSE LIGHT LENS MISSING AT ROW 17. INSTALLED LENS PER SIP.SDR SWAA2017092616625Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R BULB PER AMM.SDR SWAA2017092616624Light · inoperativeCOCKPIT EMERGENCY EXIT LIGHT INOP. R&R BULB PER MM.SDR SWAA2017092616611Fuse · inoperativeFORWARD EMERGENCY LIGHT JUST AFT OF L1 DOOR INOP. R&R FUSE PER AMM.SDR DALA2017092507079Battery Pack · inoperativeDURING A SERVICE CHECK, THE LT OVERWING EMERGENCY EXIT SIGNS WOULD NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M10568 IAW AMM 33-51, OPS CHECKED NORMAL.SDR DALA2017092307095Power Supply · inoperativeEXTERNAL EMERGENCY LIGHTS INOPERATIVE AT THE RT OVERWING DOOR. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-07-862-054.SDR DALA2017092307094Power Supply · inoperativeEXTERNAL EMERGENCY LIGHT INOPERATIVE AT THE LT OVERWING DOOR. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-07-862-054.SDR SWAA2017092516585Cover · unsecureOVERWING CENTER AISLE EXIT ROW SIGN COVER FELL OFF. SECURED COVER PER AMM.SDR SWAA2017092516553Battery Pack · dischargedLT EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER MM.SDR SWAA2017092516552Battery Pack · dischargedRT EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER MM.SDR AALA201709259008Bezel · damagedSEAT 20C FLOOR PATH LIGHTING DETACHED HANGING BY WIRE. REPLACED FLOOR PATH LIGHTING BEZEL.SDR UIEA2017092201782Light · inoperativeRIGHT SIDE AFT OF WING MIDDLE OUTSIDE EMERGENCY LIGHT INOPERAIVE. REPOSITIONED THE EMERGENCY LIGHT. OP CHECKED GOOD IAW AMM 33-51-16.SDR UIEA2017092201789Light · inoperativeL1 DOOR OUTSIDE EMERGENCY LIGHT INOPERATIVE. REPOSITIONED THE L1 DOOR EXTERIOR EMERGENCY LIGHT. OP CHECKED NORMAL IAW AMM 33-51-16.
Back to JASC 3350