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 AALA201711139024Power Supply · no testFOUND EMERGENCY POWER SUPPLY UNIT LEFT, MID BATTERY FAULT ON FLIGHT ATTENDANT PANEL. REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-38.SDR ASAA2017111022533Sign · brokenEXIT SIGN ABOVE THE ENTRY TO FLIGHT DECK IS BROKEN. GROUNDED - YES. REMOVED AND REPLACED EXIT SIGN COVER THAT WAS BROKEN.SDR ASAA2017111022519Lens · detachedAFT EXIT LIGHT COVER A/C LEFT FELL OFF. GROUNDED - YES. REPLACED LENS ON L2 DOOR INTERIOR EMERGENCY EXIT SIGN LIGHT, OP CHECK GOOD REF AMM 33-51-01.SDR SIMA20171110001Battery · dischargedLT AND RT AFT OVERWING EXIT LIGHTS INOP. REMOVED AND REPLACED NR 4 BATTERY AND CHARGER IAW WORKCARD 33-700-19 OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 19592.SDR DALA2017111308079Light · inoperativeTHE EMERGENCY LIGHT AT 19AB IS INOPERATIVE. MAINTENANCE REPLACED AND SECURED A SECTION OF EMERGENCY LIGHT STRIP IAW AMM 33-51-01. OK FOR SERVICE.SDR 29GA2017111100001Switch · failedFA REPORTED THAT THE EMERGENCY LIGHT SWITCH ARM IN YELLOW DOES NOT ILLUMINATE. TROUBLESHOT THE SYSTEM AND FOUND THE F/A EMERGENCY LIGHT SWITCH 29LN AT FAULT. R & R F/A EMERGENCY LIGHT SWITCH IAW AMM 39-40-60-02. EMERGENCY LIGHTS OPS CHECKED NORMAL IAW AMM 33-SDR CALA2017111004020Lens · missingR2 DOOR EXIT LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT LENS. OPS CHECKED GOOD. OK TO CONTINUE.SDR CALA2017111004012Lamp · inoperativeL2 EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801, OPS CHECKED NORMAL.SDR CALA2017111004010Light · damagedEMERGENCY AISLE LIGHTS ROWS 20 AND 21 DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-51-11-960-802. OPS CHECKED GOOD.SDR CALA2017111004009Light · brokenEMERGENCY EXIT LIGHT BY THE LT AFT OVERWING EXIT BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004008Light · brokenEMERGENCY EXIT LIGHT ASSY BY THE L2 DOOR IS BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004007Light · brokenEMERGENCY EXIT LIGHT ASSY BY THE R2 DOOR IS BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004006Light · crackedEMERGENCY EXIT LIGHT BY THE R1 DOOR FOUND CRACKED IN TWO PLACES. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004005Sign · detachedEMERGENCY EXIT SIGN FWD OF THE AFT GALLEY DETACHED FROM THE CEILING. SECURED THE SIGN.SDR CALA2017111004002Light · inoperativeSLIDE OVERWING LIGHT DOES NOT COME ON. LEFT SIDE CABIN EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED THE FWD RT OVERWING DOOR LIGHT.SDR CALA2017111004001Light · crackedR1 DOOR EMERGENCY LIGHT BASE CRACKED AND BROKEN. REPLACED THE EMERGENCY EXIT LIGHT BASE IAW EA 33-51-01-167.SDR CALA2017111003996Light · inoperativeEMERGENCY LIGHTS IN THE FIRST CLASS SECTION, ROWS 1D, 2D, 3D, AND CENTER SEATS DO NOT WORK.SDR CALA2017111003994Fuse · inoperativeDURING CHECK, FOUND ZONE B SEAT MOUNTED EMERGENCY LIGHTS NOT ILLUMINATED. THE POWER PACK FUSE WAS REPLACED AND LIGHTS TESTED OK IAW AMM 33-51-01.SDR CALA2017111003993Battery Pack · dischargedSEAT 22JKL EMERGENCY LIGHT FOUND DIM. THE POWER SUPPLY BATTERY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017111003992Battery Pack · inoperativeSEAT 10 LK EMERGENCY LIGHT FOUND DIM. THE POWER SUPPLY BATTERY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2017111003991Lens · damagedEXIT LIGHT LENS AT THE L2 DOOR DAMAGED. REPLACED THE LENS.SDR CALA2017111003990Lamp · inoperativeCOCKPIT OVERHEAD P5 EMERGENCY DOME LIGHT INOPERATIVE. REPLACED THE LAMP. CHECKED OK IAW AMM 33-51-07-960-801.SDR CALA2017111004000Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED OK.SDR CALA2017111003999Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP, CHECKED OK.SDR CALA2017111003995Sign · looseSIGN AT THE R3 DOOR FOUND DETATCHED FROM CEILING. SECURED THE SIGN. OK.SDR CALA2017111004014Lens · missingEMERGENCY LIGHT LENS AT SEAT 20A MISSING. REPLACED THE LENS.SDR CALA2017111004003Sign · looseR2 DOOR EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN, OK TO CONTINUE.SDR CALA2017111003980Light · brokenSEAT 27C EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSEMBLY, CHECKED OK IAW 33-00-00SDR FDEA201711103218Battery · faultedDURING PREFLIGHT, DURING AN EMERGENCY LIGHT TEST RECEIVED AN EMERGENCY LIGHT BATTERY 1 LOW DISPLAYED. PERFORMED AN OPERATIONAL TEST 4 TIMES, ALL OPS NORMAL. NO HISTORY IN 30 DAYS. IAW AMM 33-51-01-5SDR MASA2017111012753Light · inoperativeFWD OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. OPENSDR REXA2017111001159Light · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21, OPS CHECKED GOOD.SDR SWAA2017111517832Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1673 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517831Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1675 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517818Battery Pack · no testBATTERY PACK FAILED A CAPACITY CHECK AT LOCATION M01675. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2017111517817Battery Pack · no testBATTERY PACK FAILED A CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517812Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017111517811Bulb · inoperativeL2 DOOR EMERGENCY LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2017111517810Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1672 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517783Light · delaminatedRIGHT FLOOR EMERGENCY LIGHT STRIP DELAMINATED AT ROW 1. R & R THE LIGHT IAW DWG.SDR SWAA2017111517779Light · inoperativeR2 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR AALA201711109030Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE THE R2 DOOR IS MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201711109029Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN IN THE FORWARD GALLEY IS MISSING. REPLACED EXIT SIGN PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR DALA2017111008091Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED. SEAT MOUNTED EMERGENCY LIGHT PUSHED BACK AT 1C LOCATION: 1C. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS AT SEAT 1C. OPS CHECK GOOD AT THIS TIME REF AMM 33-51.SDR CALA2017111003966Sign · brokenMAIN DECK EMERGENCY LIGHT FOUND BROKEN. REPLACED THE SIGNS AND OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 81.SDR CALA2017111003965Light · brokenMAIN DECK R4 DOOR CENTER PARTITION, ONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND OPS TESTED NORMAL IAW AMM 33 -51-05-960-802, REV 81.SDR CALA2017111003964Lamp · inoperativeR3 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE BULB AND OP TESTED NORMAL IAW AMM 33-51-04-960-801, REV 81.SDR CALA2017111003967Lens · brokenMAIN DECK CEILING EMERGENCY LIGHT LENS FOUND BROKEN. REPLACED THE LENS AND OPS TESTED GOOD IAW AMM 33-51-03-960-801, REV 81.SDR HALA2017110900273Battery Pack · inoperativeFOUND EXTERIOR RIGHT AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK M733.SDR HALA2017110900272Battery Pack · inoperativeCEILING EMERGENCY LIGHTS AT ROW 36AB, AFT INOPERATIVE. EXTERIOR LEFT AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACKS AT M738 AND M739.SDR DALA2017111008056Lamp · inoperativeONE EMERGENCY LIGHT FAILED TO ILLUMINATE AT ROW 17. REPLACED THE LAMPS IAW AMM 33-51. OPS CHECKED GOOD. OK FOR SERVICE.
Back to JASC 3350