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 QXEA2017032700180Battery Pack · failedNR 1 EMERGENCY POWER SUPPLY FAILED FUNCTIONAL CHECK. REPLACED THE BATTERY BACK.SDR AALA20170323003Light · brokenR1 DOOR EMERGENCY EXIT SIGN IS BROKEN. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201703279012Light · brokenR1 DOOR EMERGENCY EXIT SIGN LOWER LEFT OF THE DOOR IS BROKEN. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-13, AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201703249009Light · brokenFOUND SIDE TRIM AND PROXIMITY LIGHT ASSEMBLY TORN OFF AT SEAT 16C. MAINTENANCE REPLACED SEAT BUMPER PANEL AND LIGHT ASSEMBLY IAW CMM 25-26-09, FIG 1, ITEM 640.SDR DALA2017032402450Lens · detachedEMERGENCY EXIT LENS DETACHED. ATTACHED THE LENSSDR AALA201703279003Lens · missingAIRCRAFT NOT GROUNDED. DOOR 4L EMERGENCY EXIT SIGN MISSING. INSTALLED NEW EMERGENCY EXIT LENS AT 4L LOWER DOOR FRAME.SDR AALA201703279001Battery · dischargedAIRCRAFT NOT GROUNDED. EPSU 11WL FAILED TEST. REPLACED EPSU 11WL BATTERY IAW AMM 33-51-38.SDR DALA2017032402398Light · inoperativeDURING SVC CK FOUND EMERGENCY LIGHTS OUT AT ROWS 8,13,AND 17. RELAMPED.SDR DALA2017032402396Battery · dischargedOVERWING EXIT EMERGENCY LIGHTS INOP. REPLACED LT OVERWING EXIT LIGHT EPSU, W/ BATTERY.SDR AALA20170324001Battery Pack · no testDURING AN EMERGENCY LIGHTING FUNCTIONAL CHECK, R4 DOOR AND ROWS 20/30 FAILED TO ILLUMINATE. REPLACED BATTERY PACK AT BS 952. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703249014Cover · missingAFT GALLEY RT SIDE COVER MISSING ON EXIT EMERGENCY LIGHT. REPLACED THE COVER IAW AMM 33-51-14.SDR DALA2017032402379Battery Pack · no testEPSU TEST GAVE 'EPSU (13WL) DOOR 2 BAT FAULT. R & R EPSU BATTERY. TEST PASSED.SDR AALA201703249006Power Supply · no testAIRCRACT FLIGHT ATTENDANT PANEL INDICATES AFT LEFT EMERGENCY POWER SUPPY UNIT FAULT DURING CABIN EMERGENCY LIGHTS TEST.REMOVED AND NSTALLED AFT LEFT EMERGENCY POWER SUPPY UNIT. (RELATED TO AALA201703249005)SDR AALA201703249005Battery Pack · dischargedFLIGHT ATTENDANT PANEL INDICATES AFT LEFT EMERGENCY POWER SUPPY UNIT FAULT DURING CABIN EMERGENCY LIGHTS TEST. REMOVED AND NSTALLED AFT LEFT EMERGENCY POWER SUPPY UNIT BATTERY. (RELATED TO AALA201703249006)SDR AALA201703249004Lens · detachedLIGHT LENS ON EMERGENCY EXIT LIGHT HAS FALLEN OFF. REPLACED EMERGENCY EXIT LIGHT LENS.SDR MASA2017032312687Light · inoperativeROW 18 CEILING LVL EMER FLOODLIGHT INOP. REPLACED BULB.SDR MASA2017032312686Light · inoperativeROW 15 CEILING LVL EMER FLOODLIGHT INOP. REPLACED BULB.SDR REXA2017032300393Light · wornRIGHT SIDE EMERGENCY EXIT LIGHT WORN IN FRONT HALF OF PASSENGER CABIN. R & R EMERGENCY LIGHT IAW AMM 33-51-01.SDR MASA2017032312685Lamp · inoperativeROW 14 EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017032312684Light · inoperativeROW 8 CEILING LEVEL EMERGENCY FLOODLIGHT INOPERATIVE.SDR DALA2017032302348Battery · dischargedAIR STAIR EMER LIGHTS INOP. REPLACED BATTERIES AFT EMER LIGHT BATTERY PACK REF AMM 33-53.SDR REXA2017032200408Battery Pack · inoperativeAFT THREE CABIN CEILING EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK NR 4 (PS38) IAW AMM 33-51-17. OPS TESTED GOOD IAW AMM 33-51-00-710-802, AND 33-51-17-710-801.SDR SWAA2017032812781Light · looseLEFT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LOOSE AT ROW 9. SECURED THE LIGHT IAW AMM.SDR SWAA2017032812780Sign · wrong partL2 DOOR EMERGENCY EXIT LIGHT SIGN MISSING RED ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017032812776Sign · wrong partR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017032812770Lens · looseLEFT OVERWING EMERGENCY EXIT LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2017032812768Lamp · inoperativeLEFT EMERGENCY EXIT ROW SIDE WALL LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR CALA2017032400687Battery Pack · dischargedSEAT 22-28 LH BULLNOSE EMERGENCY LIGHTS ONLY ILLUMINATE DIM REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-66-960-8 05. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06-9 60-806. OPS CHECKED GOOD IAW AMM 33-51-00-710-801.SDR CALA2017032400686Battery Pack · faultyR2 DOOR EMERGENCY EXIT LIGHT AT FWD LOWER POSITION REMAINS ILLUMINATED WITH EMERGENCY LIGHT SWITCH IN ANY POSITION . PERFORMED T/S IAW WDM 33-51-14. FAULTY BATTERY PACK M1556 CONFIRMED. R & R THE BATTERY PACK IAW AMM 33-51-07. OPS OK.SDR CALA2017032400682Battery Pack · inoperativeEMERGENCY LIGHT POWER SUPPLY M1561 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD.SDR CALA2017032400675Power Supply · malfunctionedRT OFF WING ESCAPE DOOR LOWER EMERGENCY EXIT IDENTIFIER SIGNS WILL NOT TURN OFF WITH SWITCH IN OFF OR AUTO. REPLACED POWER SUPPLY IAW AMM 33-51-07 AND TESTED NORMALLYSDR AALA201703249013Ballast · inoperativeRIGHT WING EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. SEAT 15F. REMOVED AND REPLACED THE BALLAST IAW AMM 33-21-00. OPS CHECKED GOOD.SDR AALA201703239018Switch · damagedNOSE LANDING GEAR EMERGENCY LIGHT SWITCH IS DAMAGED. REMOVED AND REPLACED SWITCH S10035 IAW WDM 33-51-11. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR DALA2017032302380Sign · broken3R AISLE EXIT SIGN BROKE, THE FRAME IS CRACKED. R & R EXIT SIGN HOUSING, OPS CHECKED GOOD.SDR DALA2017032302378Battery Pack · no testBATTERY PACK AND EPSU FAILED SELF TEST,SDR AALA201703239005Power Supply · faultyEMERGENCY EXIT LIGHTS INOPERATIVE AT SEATS 12, 16, 20, 27, AND 32. THE POWER SUPPLY UNIT 11WL WAS FAULTING, REPLACED THE POWER SUPPLY.SDR AALA201703239004Lens · missingEMERGENCY LIGHT LENS AT THE R1 DOOR MISSING. INSTALLED A NEW LENS.SDR AALA201703239003Lens · missingEMERGENCY LIGHT LENS AT THE R4 DOOR MISSING. INSTALLED A NEW LENS.SDR AALA201703239002Lens · missingTHE L4 DOOR EXIT SIGN LENS MISSING. INSTALLED NEW LENS.SDR AALA201703239031Lens · missingEXIT LENS COVER ON 1R DOOR MISSING. REMOVED & REPLACED 1R DOOR EMERGENCY LIGHT LENS COVER PER M/M 33-50-00. CONT SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703239030Battery Pack · dischargedO/H EMERG LIGHTS INOP FROM L2 DOOR TO PAX SEAT AT ROW 13B. MAINTENANCE REPLACED BATTERY PACK AT L2 DOOR. THE AIRCRAFT WAS NOT GROUNDED.SDR SIMA20170322002Sign · inoperativeCENTER AISLE CEILING EMERGENCY EXIT SIGN LIGHT INOP. REMOVED AND REINSTALLED CENTER AFT CEILING EMERGENCY EXIT SIGN IAW AMM 33-50-15 AND 33-50-00 OPS CHECK GOOD.SDR SIMA20170322003Light · inoperativeSERVICED DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-09-000-801-A & 33-50-09-400-801-A. OPS CHECK GOOD AT THIS TIME END.SDR DALA2017032302355Battery Pack · dischargedBOTH EMERGENCY "EXIT" SIGNS AT DOOR 3L INOP. REPLACED BATTERY PACK M33406 PER AMM 33-51-06.SDR FDEA201703220970Switch · bentON ARRIVAL, DURING CONNECT FLT INTERPHONE FOUND EMER EXIT LIGHT TEST SWITCH BENT ON NLG. REPLACED THE TEST SWITCH.SDR YENA201703220204Battery Pack · no testDURING ROUTINE MAINTENANCE, EMERGENCY LIGHT FAILED TO TEST. R & R THE BATTERY PACK AT EPSU 10WL. LIGHT TESTED OK IAW AMM 33-51-38.SDR DALA2017032202286Power Supply · inoperativeCABIN CEILING EMERGENCY LIGHTS ARE OUT. REPLACED THE POWER SUPPLY AND OPS CHECKED NORMAL IAW AMM 33-51.SDR SWAA2017032812777Sign · crackedL1 DOOR EMERGENCY EXIT SIGN CRACKED. R & R THE SIGN IAW SIP.SDR SWAA2017032812771Battery Pack · no testFORWARD LEFT EMERGENCY BATTERY PACK FAILED A FUNCTIONAL TEST FOR CAPACITY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017032812739Lens · looseLEFT EMERGENCY LIGHT LENS LOOSE AT ROW 14. INSTALLED THE LENS IAW AMM.
Back to JASC 3350