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 SIMA20171225001Battery · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-50-04. OPS CHECKED GOOD.SDR MASA2017122512858Bulb · inoperativeROW 21 EMERGENCY CEILING FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR KCSA201712251092Light · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE.SDR MASA2017122512857Light · inoperativeROW 1 EMERGENCY CEILING LIGHT INOPERATIVE.SDR CALA2017122504602Fuse · failedSEAT 15C AISLE WAY EMERGENCY EXIT INDICATOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE FUSE AT M1694 EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06-960-804. OPS CHECKED GOOD IAW AMM 33-51-06-960-804.SDR CALA2017122504601Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE FROM ROW 20 BACK, LT AND RT SIDES AND SEATS FROM ROW 22 BACK, FAILED A TIME CHECK. REMOVED AND REPLACED BOTH AFT CEILING BATTERY PACKS AND CHARGERS. FIXED THE AFT LIGHTS BUT ROW 20 TO 31 AND BULL NOSE LIGHTS STILL INOPERATIVE. SDR CALA2017122504600Lens · missingSEAT 8C OVERHEAD BIN EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS, AND OPS GOOD. OK TO CONTINUE.SDR CALA2017122504599Light · brokenFWD GALLEY BS 217 FACING ON RIGHT SIDE LOWER EMERGENCY LIGHT COVER AND BULB BROKEN. REPLACED THE LIGHT ASSY. OPS OK.SDR CALA2017122504598Lens · crackedDURING CHECK OF THE EMERGENCY LIGHT FUNCTION, FOUND THAT THREE EMERGENCY LIGHTS LENS CRACKED. REPLACED THE EMERGENCY LIGHTS, TESTED AND FOUND NORMAL IAW AMM 33-51-05-960-003, REV 81.SDR CALA2017122504597Battery Pack · no testEMERGENCY LIGHT DEEP CYCLE TEST FOUND THE R2, L3, AND R4 DOOR BATTERY PACKS CAPACITY LOW. THE EMERGENCY BATTERY PACKS AND POWER SUPPLIES REPLACED. CARRIED OUT INSTALLATION TEST FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81 AND AMM 33-51-06-960-803, REV 81.SDR CALA2017122504604Lens · missingFLOOR EMERGENCY LIGHT DOES NOT TURN ON. LENS MISSING AND WIRES EXPOSED. R & R THE LENS. OPS CHECKED NORMAL.SDR SWAA2018010318756Lens · brokenLT EMERGENCY BULLNOSE LIGHT LENS BROKEN AT ROW 12. R&R LIGHT IAW AMM.SDR AALA201712269029Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EXIT EMERGENCY LIGHT DOOR 4L INOPERABLE. REPLACED EMERGENCY EXIT LIGHT AT DOOR 4L. OPERATIONS CHECK GOOD.SDR SWAA2017122918666Lens · missingL2 DOOR EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW MM.SDR AALA201712279015Power Supply · inoperativeAIRCRAFT GROUNDED. EMERGENCY EXIT LIGHTS ILLUMINATE OCCASIONALLY BY THE 3R DOOR IN FLIGHT. REPLACED 12WL EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38. OPERATIONS CHECK OK.SDR AALA201712269042Power Supply · inoperativeEMERGENCY EXIT LIGHTS ILLUMINATE OCCASIONALLY BY THE L3 DOOR IN FLIGHT. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPERATIONS CHECK OK. AIRCRAFT GROUNDED.SDR AALA201712269032Light · inoperativeEMERGENCY EXIT LIGHT, AT THE R2 DOOR INOPERATIVE. REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR AALA20171225001Lens · brokenEMERGENCY LIGHT LENS BROKEN AT ROW 14 F, LOWER SIDEWALL. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01.SDR SWAA2017122818681Lens · missingRIGHT OVERWING EXIT LIGHT LENS MISSING. INSTALLED THE LIGHT ASSY IAW MM.SDR SWAA2017122818626Lens · missingEXIT LIGHT LENS MISSING AT ROW 12 DEF. INSTALLED A LENS IAW MM.SDR SWAA2017122818611Lens · looseR1 DOOR LOWER EMERGENCY LIGHT LENS FOUND LOOSE. SECURED THE LENS IAW MM.SDR AALA201712279038Lens · brokenLENS BROKEN ON EXIT SIGN ROW 14F, LOWER SIDEWALL. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201712279039Cover · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER MISSING NEAR RIGHT AFT GALLEY DOOR. REPLACED AFT EXIT SIGN LIGHT ASSY IAW AMM 33-51-01.SDR AALA201712269025Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L/H BULKHEAD BETWEEN GALLEY AND FIRST CLASS LOOSE. HANGING BY WIRES. RESECURED EMERGENCY EXIT MARKER.SDR HALA2017122700322Lens · detachedEMERGENCY EXIT LIGHT LENS OVER THE R3 DOOR DETACHED. REPLACED THE LENS IAW AMM 33-51-17. OK FOR SERVICE.SDR DALA2017122708919Power Supply · inoperativeON SERVICE CHECK, MAINTENACE FOUND FOUR EMERGENCY EXIT LIGHTS, IN THE TAIL COMPARTMENT PASSAGE WAY TO BE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND BATTERY (B5-260) IAW AMM 33-51. OPS CHECK WAS NORMAL.SDR REXA2017122401290Light · missingSEVEN INCHES OF THE EMERGENCY LIGHT STRIP MISSING. LT SIDE AFT. R & R THE LT AFT EMERGENCY LIGHT STRIP IAW AMM 33-51-01.SDR ASAA2017122422989Lamp · failedEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO LEFT AFT OVERWING EXIT IS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP AND TESTED IAW MM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017122422988Lamp · failedEMERGENCY LIGHT EXTERIOR SLIDE LIGHT AT RIGHT AFT OVERWING EXIT IS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP AND TESTED IAW AMM 33-51-04-960-801, OPS NORMAL.SDR DALA2017122608891Battery Pack · inoperativeDURING INSPECTION, FOUND EMERGENGY LIGHTS FAILED AT THE EMERGENCY EXIT AFT LEFT, FWD LEFT AND AFT SEAT MOUNTED LIGHTS. MAINTENANCE R & R THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-06. OPS CHECKED OK.SDR DALA2017122608874Battery Pack · failedOVERHEAD EMERGENCY LIGHTS AT ROWS 10 AND 13 INOPERATIVE. FOUND THE BATTERIES BAD AT SEAT ROWS 10 THRU 13 AND REPLACED IAW SPWM 20 AND EWIS. OPS CK GOOD.SDR CALA2017122404593Switch · malfunctionedOVERHEAD EMERGENCY LIGHTS INOPERATIVE. EMERGENCY EXIT LIGHTS STAY ON WITH SWITCH IN ARM. RESET THE EMERGENCY LIGHTS SWITCH ON AFT FLT ATTENDANT PANEL. OP CHECKED OK. IAW AMM 33-51-00.SDR CALA2017122404591Cover · missingFIRST CLASS CLOSET WHITE EMERGENCY EXIT LIGHT MISSING CLEAR COVER. REPLACED THE COVER IAW AMM 33-51-13.SDR CALA2017122404590Shroud · damagedSEAT MOUNTED EMERGENCY EXIT LIGHT SHROUD DAMAGED AT FWD LEFT EXIT HATCH. REPLACED LIGHT SHROUD. EMERGENCY EXIT LIGHT OPS CK NORMAL.SDR CALA2017122404583Power Supply · inoperativeEMERGENCY LIGHTS IN BULL NOSE AT ROWS 23ABC, 22DEF, & 12DEF INOPERATIVE. FOUND A LOOSE CONNECTOR AT BS 706. SECURED AND OPS CHECKED OK ON SEAT ROW 23 ABC REF AMM 33-51-11. REPLACED THE POWER SUPPLY, OPS CHECKED OK IAW AMM 33-51-06SDR MASA2017122412855Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERY PACKS.SDR AALA201712269066Lens · damagedFORWARD AISLE EMERGENCY LIGHT LENS NOT CLEAR. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01.SDR SWAA2017122818610Light · looseMID CABIN EMERGENCY EXIT LIGHT LOOSE. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017122818609Light · inoperativeEMERGENCY LIGHT INOP AT THE RT FWD END. R & R THE EMERGENCY LIGHT SECTION IAW MM.SDR AALA201712269048Lens · missingRIGHT AFT OVERWING EMERGENCY DOOR MISSING THE EXIT SIGN LENS. REPLACED THE LENS.SDR AALA201712269038Cover · missingAIRCRAFT NOT GROUNDED. SEAT 10ABC EMERGENCY LIGHT COVER MISSING. REPLACED SEAT 10ABC EMERGENCY LIGHT COVER PER AMM 33-51-19.SDR AALA201712269036Cover · missingAIRCRAFT NOT GROUNDED. 2L EMERGENCY EXIT DOOR LIGHT COVER MISSING. REPLACED 2L EMERGENCY EXIT DOOR LIGHT COVER LENS.SDR 7C7A2017122700349Light · inoperativeLOWER EMERGENCY LIGHT AT AIRSTAIR ENTRANCE IS NOT COMING ON WHEN EMERGENCY LIGHT SWITCH IS TURNED ON.SDR AALA201712269072Sign · detachedAIRCRAFT WAS NOT GROUNDED. AFT LEFT EXIT EMERGENCY EXIT SIGN FELL OFF WALL. REPLACED EMERGENCY EXIT SIGN ASSEMBLY PER AMM 33-51-01.SDR ASAA2017122322987Lens · detachedEXIT SIGN AT MID-CABIN EXIT ROW MISSING AFT LENS. ACFT GROUNDED. INSTALLED A NEW LENS. OPS NORMAL.SDR REXA2017122301284Light · inoperativeEXTERIOR LEFT AFT EMERGENCY LIGHT INOPERATIVE.SDR JJBA20171223013Bulb · inoperativeGALLEY EMERGENCY LIGHT INOPERATIVE. R & R THE BULBS IAW AMM 33-29-03. OPS CHECKED GOOD.SDR JJBA20171223014Bulb · inoperativeEMERGENCY LIGHT AT ROW 18 CD INOPERATIVE. REMOVED AND REPLACED THE BULBS AND PERFORMED AN OPS CHECK IAW AMM 33-50-00. OPS CHECKED GOOD.SDR DALA2017122608895Spring · detachedEMERGENCY LIGHT COVER SPRING DETACHED. R & R EMERGENCY LIGHT IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2017122608894Lens · missingEMERGENCY EXIT LIGHT LENS AT SEAT 26A MISSING. REPLACED THE LENS IAW AMM 33-51.
Back to JASC 3350