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 AALA201705309051Sign · detachedEMERGENCY EXIT SIGN AT L2 DOOR IS DETACHED. INSTALLED EXIT SIGN IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA201705309050Charger · inoperativeFORWARD EMERGENCY EXIT SIGN AFT OF COCKPIT DOOR AND R1 DOOR IS INOPERATIVE. REMOVED AND REPLACED CHARGER ASSEMBLY AND EMERGENCY BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201705309045Lens · missingEMERGENCY EXIT LIGHT BY THE L2 DOOR HAS A MISSING LENS. INSTALLED A NEW LENS IAW AMM 25-60-00. OPERATIONAL CHECKED GOOD.SDR SWAA2017053114053Sign · detachedR1 DOOR EXIT SIGN FELL OFF. REPLACED THE EXIT SIGN IAW MM.SDR AALA201705309026Lens · unsecureEXIT LIGHT SIGN AT FLOOR LEVEL KEEPS FALLING OFF. REPLACED EXIT DOOR LIGHTED SIGN , OPS NORMAL.SDR AALA201705309023Lens · missingL4 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201705309020Lens · brokenBROKEN CEILING PANEL EMERGENCY LIGHT LENS IN PASSENGER CABIN. REPLACED THE LENS.SDR AALA201705309043Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT THE L2 DOOR INOPERATIVE. REPLACED THE BATTERY PACK.SDR AALA201705309041Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEAT 11B. REPAIRED EMERGENCY LIGHT ASSY.SDR QXEA2017053000377Battery Pack · inoperativeAFT OVERHEAD EMERGENCY LIGHT DOES NOT REMAIN ILLUMINATED WHEN EMERGENCY LIGHTS ARE ON. MOMENTARILY LIGHTS UP THEN EXTINGUISHES. REMOVED AND REPLACED AFT OVERHEAD BATTERY PACKS PER 33-51-01 OPS CHECK NORMAL.SDR REXA2017052900645Battery · inoperativeLT AND RT EXTERIOR AFT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-17, OPS NORMAL.SDR IPXA2017053017677Power Supply · no testEMERGENCY LIGHT TEST FAILED. REMOVED & REPLACED THE POWER SUPPLY IAW AMM 33-51-01, OPS CHECKED NORMAL.SDR DALA2017052904338Battery Pack · faultedDURING AN EMERGENCY LIGHT TEST A BATTERY 14WL FAULTED. R & R THE BATTERY PACK. TESTED OK.SDR DALA2017053004337Power Supply · inoperativeTHE EMERGENCY LIGHTS HAD MULTIPLE LIGHT FAILURES. REMOVED AND REPLACE THE POWER SUPPLIES 11WL AND 13WL.SDR CALA2017052901638Light · inoperativeEMERGENCY EXIT SEAT LIGHT INOPERATIVE AT SEAT 34C. REMOVED AND REPLACED EMERGENCY EXIT SEAT LIGHT. OPS CHECKED GOOD.SDR CALA2017052901635Sign · detachedFWD GALLEY EMERGENCY EXIT SIGN IS FALLING DOWN. SECURED IN PLACE.SDR YENA201705280454Battery · failedEMERGENCY LIGHT BATTERY FAULT AT FIN 13WL. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-38.SDR YENA201705280453Battery · failedEMERGENCY LIGHT BATTERY FAULT AT 12WL. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-38.SDR YENA201705280444Battery Pack · failedDURING HEAVY MAINTENANCE, EPSU FAULT AFT LT BATTERY. R & R THE BATTERY PACK 13WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201705280431Battery Pack · inoperativeDURING HEAVY MAINTENANCE, THE L2 DOOR LOWER EMERGENCY EXIT SIGN DID NOT ILLUMINATE. R & R THE BATTERY IAW AMM 33-50-01, OPS CHECKED GOOD IAW AMM 33-50-00.SDR AALA201705319030Lens · missingEXIT SIGN LENS AT CENTER FUSELAGE MISSING. REPLACED THE LENS IAW AMM 25-63-00. GOOD FOR SERVICE.SDR AALA201705299014Lens · missingFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW MM 33-51-02.SDR DALA2017053004423Cover · unknownDOOR 3R EXIT SIGN LOOSE/MISSING COVER. REATTACHED OPS NML AMM REF 33-51.SDR DALA2017053104413Battery Pack · dischargedFIRST CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE, ROWS 1 THRU 5. REMOVED AND REPLACED BATTERY PACK AT ROW 4C. OPERATION CHECKS GOOD.SDR AALA201706019007Power Supply · no testEMERGENCY LIGHTS POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201706019006Power Supply · failedEMERGENCY LIGHTS POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201706019005Power Supply · no testEMERGENCY LIGHTS POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201706019004Power Supply · no testEMERGENCY LIGHTS POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201706019003Power Supply · no testEMERGENCY LIGHTS POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170528002Power Supply · no testEMERGENCY LIGHT POWER SUPPLIES M1671, M1672, M1673, M1675, M1694 AND M1695 FAILED MCM CARD 2908 CAPACITY TEST. REMOVED AND REPLACED THE POWER SUPPLIES IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201705299008Battery · no testEMERGENCY POWER SUPPLY UNIT BITE TEST MESSAGE, BATTERY 10WL FAIL. REPLACED BATTERY PACK IAW MM 33-50-00.SDR AALA201705319029Light · brokenEMERGENCY LIGHT ON LOWER WALL BY FIRST CLASS GALLEY BROKEN. REPLACED PLASTIC BASE FOR LIGHT ASSY. OPS OK AMM 33-50-00.SDR AALA201705299013Sign · brokenEXIT SIGN IS BROKEN. REMOVED AND REPLACED THE SIGN ASSY IAW MM 33-51-01. OPS CHECKED OK.SDR AALA201705299012Light · brokenEMERGENCY EXIT LIGHT COVER PLATE IS BROKEN OFF. REPLACED EMERGENCY EXIT ASSY IAW AMM 33-51-14. OPS CHECKED OK.SDR AALA201705299011Cover · missingEXIT SIGN COVER AT CENTER FUSELAGE MISSING. EXIT SIGN COVER AT CENTER FUSELAGE WAS INSTALLED IAW AMM 25-63-00. GOOD FOR SERVICE.SDR 29GA2017053100001Circuit Breaker · trippedL8 EMERGENCY LIGHT CIRCUIT BREAKER TRIPPED IN FLIGHT. REPLACED THE CIRCUIT BREAKER, OPERATIONAL TESTED GOOD.SDR 29GA2017052800002Circuit Breaker · poppedL8 EMERGENCY LIGHT CIRCUIT BREAKER TRIPPED IN FLIGHT . REPLACED THE CIRCUIT BREAKER, OPERATIONAL TESTED GOOD.SDR AALA201705299009Sign · missingEMERGENCY EXIT SIGN AT R1 DOOR IS MISSING. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.SDR RAIA201705280002Bulb · intermittentSERVICE DOOR FLOOD LIGHT NR 8, INTERMITTENT. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201705280001Bulb · inoperativeMAIN DOOR FLOOD LIGHT NR 13 FOUND INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR AALA20170528001Light · brokenR2 DOOR EMERGENCY LIGHT IS BROKEN. REPLACED THE LIGHT ASSEMBLY IAW MM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017053114067Light · looseMID CABIN EMERGENCY EXIT LIGHT LOOSE. SECURED THE LIGHT ASSY IAW MM.SDR AALA201705309037Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE SEAT MOUNTED EMERGENCY LIGHTSDR AALA201705309035Lens · missingRED EMERGENCY LIGHT AT AISLE SEAT 22D HAS THE LENS MISSING. REPLACED RED EMERGENCY LIGHT AT 22D..SDR AALA201705309029Lens · brokenSMALL EXIT LIGHT COVER BROKEN NEAR THE L1 DOOR JUMPSEAT. REPLACED EXIT COVER.SDR AALA201705309025Lens · detachedEXIT LIGHT LENS FELL OFF THE L1 DOOR. INSTALLED A NEW LENS.SDR ASAA2017052820911Lamp · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO LEFT AFT OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW MM 33-51-01-960-801, OPS NORMAL.SDR DALA2017052804332Control Unit · no testAFT EPCU WON'T TEST. REPLACED THE AFT EPCU.SDR SWAA2017053014040Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 18 DEF. REPLACED THE LAMP IAW MM.SDR SWAA2017053014039Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 23 ABC. REPLACED THE LAMPS IAW MM.
Back to JASC 3350