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 AALA201706059030Battery · no testEPSU FAILED A SYS TEST AT 18WL. REPLACED EPSU BATTERY.SDR AALA201706059029Battery · no testEPSU FAILED A SYS TEST AT 16WL. REPLACED EPSU BATTERY.SDR AALA201706059028Battery · no testEPSU FAILED A SYS TEST AT 15WL. REPLACED EPSU BATTERY.SDR AALA201706059027Battery · no testEPSU FAILED A SYS TEST AT 14WL. REPLACED EPSU BATTERY.SDR AALA201706059026Battery · no testEPSU FAILED SYS TEST AT 13WL. REPLACED EPSU BATTERY AT 13WL.SDR IPXA2017060417857Lamp · inoperativeINSPECTION TYPE: C11, FOUND EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED EXTERIOR EMERGENCY LIGHT LAMP IAW AMM 33-51-16-962-001, REV 121. PERFORMED TEST OF THE LAMP IAW AMM 33-51-16-962-001, REV 121.SDR DALA2017060404461Power Supply · inoperativeFORWARD CABIN NR 2 POWER SUPPLY FOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY POWER SUPPLY IAW AMM 33-51. AIRCRAFT IS OK FOR SERVICE.SDR SWAA2017061214282Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2017061214249Cover · brokenEXIT ROW SIGN COVER BROKEN. R&R LIGHT BASE ASSEMBLY PER MM.SDR DALA2017060504592Battery · inoperativeFOUND 12WL RT EXIT EPSU BATTERY FAULT, REPLACED THE BATTERY.SDR AALA201706069018Tie · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN FWD OF DOOR 3L WITH TIE WRAPS BROKEN. REMOVED AND REPLACED TIE WRAPS OF EXIT SIGN FWD OF DOOR 3L IAW 33-51-01-2. GOOD FOR SVC.SDR AALA201706069017Lens · detachedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER R1 DETACHED. INSTALLED AND SECURED LENS AT R1 EMERGENCY LIGHT ASSY. OP CKD OK IAW AMM 33-51-00.SDR AALA201706069016Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER BESIDE DOOR 1R FELL OFF AND LOOKS TO BE DAMAGED. REMOVED AND REPLACED BESIDE R1 DOOR, EMERGENCY LIGHT ASSEMBLY IN REFERENCE WITH AMM 33-51-00. EMERGENCY LIGHTS TEST GOOD.SDR AALA201706069012Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. 1R DOOR MISSING EXIT SIGN. REPLACED 1R EMERG LIGHT ASSY PER MM 33-51-14 OPS CHK NORMAL.SDR IPXA2017060617970Lens · missingEMERGENCY LIGHT LENS AT COCKPIT ENTRANCE MISSING. REPLACED THE LENS.SDR AALA201706059009Power Supply · no testAFT CABIN EMERGENCY EXIT SEAT LIGHTS INOPERATIVE. REPLACED AFT CABIN EMERGENCY POWER SUPPLY UNIT (13WL) IAW AMM 33-51-38-400.SDR DALA2017060504544Lens · unsecureEMERGENCY LIGHT LENS UNSECURE AT THE R1 CLOSET WALL, SECURED THE LENS.SDR ASOA201706035081Battery Pack · unsecurePILOT REPORTED THE FLOOR EMERGENCY LIGHTS INOPERATIVE FROM ROWS 8 TO 18, EMERGENCY DOORS AND BACKSIDE OF THE CEILING PANEL ROW 18. MX FOUND NR 3 EMERGENCY LIGHT BATTERY UNSECURE, SECURED AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201706069013Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. LENS COVER MISSING FROM ROW 3E/F AFT EMERG LIGHT. INSTALLED SERVICEABLE LENS AT AFT EMERG LIGHT ROW 3E/F AS REQUIRED PER CARD 2904.SDR SWAA2017060614189Lens · missingLT EMERGENCY EXIT LOWER LENS COVER MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017060614177Light · brokenEXIT SIGN LIGHT ASSEMBLY BROKEN AT ROW 12. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017060614176Lens · brokenR1 DOOR FLOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS IAW SIP.SDR AALA201706059046Bulb · unsecureEMERGENCY EXIT EXTERIOR SLIDE LIGHT AT L4 DOOR IS INOPERATIVE. SECURED THE BULB IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR DALA2017060604512Light · inoperativeDURING INSPECTION FOUND ROW 18 EMERGENCY EXIT AISLE LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED ROW 18DEF EMERGENCY EXIT AISLE LIGHT PER AMM 33-52. OPS GOOD.SDR DALA2017060504506Light · inoperativeR1 DOOR EMERGENCY LIGHT AFT OF DOOR ON EXTERNAL INOP. REPLACED BULB AND BATTERY CHARGER ASSY.SDR CALA2017060401664Battery · inoperativeL3 DOOR AREA, EMERGENCY LIGHT BATTERY INOPERATIVE. REPLACED CABIN LT NR 3 DOOR AREA EMERGENCY BATTERY AND CARRY OUT OP TESTED FOUND GOOD IAW AMM 33-51-06-960-803, REV.80.SDR SIMA20170603001Inverter · failedCENTER AISLE OVERHEAD EMERGENCY EXIT LIGHT AT SERVICE DOOR INOPERATIVE. REMOVED AND REPLACED NR 1 BATTERY POWER SUPPLY IAW AMM 33-50-04, OPS CHECKED FAILED. REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT DC & AC INVERTER IAW AMM 33-50-11, AND OPS CHECKED FAISDR SIMA20170603003Bulb · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT COVER BROKEN AND LIGHT INOPERATIVE. MAIN CABIN DOOR EMERGENCY LIGHT COVER AND LIGHT BULB REPLACED IAW AMM 20-21-00SDR AALA201706059021Sign · detachedEXIT SIGN AT THE R3 DOOR DETACHED. INSTALLED EXIT SIGN IAW MM 33-51-25.SDR SWAA2017060514118Lens · missingFORWARD LEFT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED THE LENS IAW AMM.SDR IPXA2017060517905Light · inoperativeLAVATORY AUXILIARY MIRROR LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-21-0401. OPS CHECKED GOOD.SDR DALA2017060404476Battery · dischargedDURING SVC CHK FOUND EMERGENCY WING EXIT SIGNS NOT ILLUMINATING. REPLACED BATTERIES IN TWO BATTERY PACKS IAW AMM 33-53-00. OPS CHK GOOD.SDR JJBA20170603003Battery Pack · inoperativeEMERGENCY LIGHTS WILL NOT TURN ON. R & R THE BATTERY PACK, OPS CHECKED GOOD.SDR DALA2017060304457Battery · dischargedAFT OVERWING EMER EXIT DOOR LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED EMERGENCY LIGHTS BATTERY B5-230 REF AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR SWAA2017061214285Lens · discoloredLT OVERWING EMERGENCY EXIT DOOR LIGHT LENS DISCOLORED. R&R LENS PER AMM.SDR SWAA2017061214273Lens · discoloredRT OVERWING EMERGENCY EXIT DOOR LIGHT LENS DISCOLORED. R&R LENS PER AMM.SDR SWAA2017060714207Sign · looseR2 DOOR AFT GALLEY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SWAA2017060614173Lens · looseRT EMERGENCY LIGHT LENS LOOSE AT ROW 8. SECURED LENS IAW MM.SDR DALA2017060504513Light · inoperativeEMER LIGHT IN SEAT 18F INOP. REPLACED LIGHT ASSY.SDR DALA2017060604507Sign · unsecureEXIT SIGN 18D 2R DOOR AND TRIM PIECE AT SEAT 1 A FELL OFF. REINSTALLED COVER AND EXIT SIGN.SDR AALA201706059071Cover · looseAFT LEFT SIDE EXIT LIGHT COVER LOOSE. REPLACED AFT LEFT EXIT LIGHT ASSY IAW 33-51-01 - OPS GOOD - OK FOR SERVICE.SDR AALA201706059070Light · damagedEMERGENCY EXIT LIGHT ASSY IN DOOR PASSENGER AFT DAMAGED. EMERGENCY EXIT LIGHT ASSY IN DOOR PASSENGER AFT WAS REPLACED IAW AMM 25-63-00. GOOD FOR SERVICE.SDR ASAA2017060220954Ground Wire · failedROW 1 EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. CHECKED WIRING AT LIGHT ASSY L1505, FOUND A BAD GROUND. RESEATED THE GROUND, OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA201706059042Lens · missingEMERGENCY EXIT IDENTIFIER AT THE L3 DOOR HAS A MISSING LENS. INSTALLED LENS IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.SDR SIMA20170602004Lamp · inoperativeLEFT OVERWING EMERGANCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR DALA2017060504477Light · inoperativeDURING INSPECTION FOUND DOOR 2L EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE RELAMPED 2L EXTERIOR EMERGENCY LIGHT PER AMM 33-51. OPS CHECK IS GOOD.SDR DALA2017060404438Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED AT POSITION 405. REPLACED EMERGENCY LIGHTING LENS COVER.SDR DALA2017060404435Light · inoperativeEMERGENCY PATH LIGHTS AT BUSINESS CLASS SEATS 10, 11, 12, BOTH SIDES. REPLACED EXTERNAL LAMP AND LIGHT PACK AT DOOR 2R POWER SUPPLY FUSE NR 2.SDR DALA2017060304434Lens · missingRED EMERGENCY FLOOR PATH RED LENSES MISSING AT DOORS 3R, 4R AND 4L. INSTALLED RED LENSES ON EMERGENCY PATH LIGHTS.SDR MASA2017060212345Light · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.
Back to JASC 3350