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 SIMA20170815004Light · inoperativeCABIN EMERGENCY LIGHT FLOOR PROXIMITY STRIP 6 INOP. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD.SDR SIMA20170815003Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. R&R LT OVERWING LIGHT IAW AMM 33-50-10 AND REMOVED AND REPLACED NR 4 BATTERY AND CHARGER ASSEMBLY IAW AMM 33-50-04 OPS CHECK GOOD.SDR SIMA20170815001Battery · dischargedREPLACE NR 4 EMERGENCY LIGHT BATTERY. REMOVED AND REPLACED NR 4 EMER BATTERY IAW AMM 33-50-04. OPS CK GOOD.SDR RAIA201708150002Lens · crackedEMERGENCY LIGHT LENS CRACKED. R & R THE LENS. OPS CHECKED GOOD.SDR IPXA2017081520585Spring · brokenSPRING ON EMERGENCY EXIT LIGHT SWITCH BROKEN. R & R SWITCH GUARD IAW AMM 33-51-00, REV 121.02.SDR MASA2017081512542Power Supply · inoperativeGALLEY EXIT SIGN INOPERATIVE. MX REPLACED THE POWER SUPPLY.SDR DALA2017081606261Switch · malfunctionedEMERGENCY LIGHTS AT THE L2 & 3 DOORS WOULD NOT EXTINGUISH DURING FLIGHT. CYCLED EMERGENCY LIGHT SWITCH, OPERATIONAL CHECKED OK.SDR DALA2017081606258Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED THE SIGN, CHECKED OK.SDR CALA2017081802708Fuse · failedEMERGENCY EXIT SIGN ABOVE THE R2 DOOR FOUND INOPERATIVE. TROUBLESHOT AND FOUND A FUSE TO BE BAD, REMOVED AND REPLACED FUSE IN THE POWER SUPPLY M732, OPS TESTED GOOD IAW WDM 33-51-13, AND AMM 33-51-07-962-071.SDR SWAA2017081815776Lens · missingEMERGENCY EXIT AISLE LIGHT LENS MISSING. REPLACED THE LENS IAW MM.SDR SWAA2017081815772Lamp · inoperativeLEFT OVERWING EXIT DOOR EMERGENCY FLUORESCENT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR AALA201708169004Lens · detachedEXIT SIGN OVER THE L3 DOOR KEEPS FALLING OFF. MAINTENANCE REPLACED EXIT SIGN LENS IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708169003Light · looseEMERGENCY LIGHT STRIP LOOSE AT SEAT 12D. REPAIRED THE LIGHT STRIP IAW MM 20-00-00.SDR A6WA201745197Light · inoperativeEMER EXIT FLOOR LIGHTING FROM ROW 8-5 INOP. RT EMER EXIT LIGHT ON SIDEWALL IS INOP. INSPECTED FLOOR TRACK LIGHTING. NO DAMAGE NOTED. NO DAMAGE TO SIDEWALL LIGHT. NO OTHER LIGHTS INOP. REF 316335/4 FOR MEL.SDR AALA201708169026Sign · unsecureTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN FWD ENTRY FELL OFF. REPLACED EMERGENCY LIGHT ASSEMBLY AT FORWARD GALLEY PER MM 33-51-14. OPS CHECK NORMAL.SDR AALA201708169025Lens · unsecureTHE AIRCRAFT WAS NOT GROUNDED. AFT LEFT GALLEY EMERGENCY LIGHT LENS NOT SECURE. REMOVED AND REPLACED AFT GALLEY EMERGENCY EXIT LENS, AMM 33-51-00, NOW OK FOR SERVICE.SDR SWAA2017081615749Cover · missingL1 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER PER AMM.SDR SWAA2017081615745Light · missingG1 GALLEY EMERGENCY EXIT LIGHT MISSING. INSTALLED LIGHT ASSEMBLY IAW AMM.SDR DALA2017081706274Power Supply · inoperativeMULTIPLE CATWALK EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY UNIT IAW WDM. OPERATION CHECKS GOOD.SDR AALA201708169033Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER BY THE L4 DOOR IS LOOSE. SECURED EXIT SIGN IDENTIFIER PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR MASA2017081412541Battery Pack · inoperativeFO FLASHLIGHT LED NOT BLINKING. REPLACED BATTERY.SDR DALA2017081506257Sign · detachedEMERGENCY EXT SIGN HAS BEEN KNOCKED OFF. MAINTENANCE REINSTALLED THE SIGN AND OPERATIONAL CHECKS ARE GOOD.SDR A6WA201745182Inverter · inoperativeEMERGENCY EXIT FLOOR LIGHTING ROW 5-8 AND RT OVERWING EXIT INOPERATIVE. REMOVED AND REPLACED THE NR 3 INVERTER IAW AMM 33-31-07-04, SYSTEM OPS CHECKED GOOD.SDR SIMA20170814002Battery · dischargedEMERGENCY FLOOR PATH STRIPS 2 AND 3 INOP. REMOVED AND REPLACED NR 2 EMERGENCY BATTERY AND POWER SUPPLY IAW MX WC 33-700-19.SDR SIMA20170814003Battery · dischargedEMERGENCY FLOOR LT STRIPS 2 AND 3 INOP. EMERGENCY BATTERIES CHARGED WITH GPU PER AMM 20-40-01-860-801-A. PERFORMED OPC OF EMERGENCY LIGHTING SYSTEM IAW AMM 33-50-00-700-801-A NO FAULTS FOUND.SDR C77A20170815001Power Supply · inoperativeAFT GALLEY EMERGENCY EXIT SIGN NOT ILLUMINATING. REMOVED & REPLACED THE NR 3 ELPU IAW AMM 3-50-01/400. OPS CHECKED IAW AMM 33-50-01-710-801-A. OPS CHECKED GOOD. OK FOR SERVICE.SDR JJBA20170814013Light · inoperativeEMERGENCY LIGHTS ROW 18 INOPERATIVE. PERFORMED ADJUSTMENT. OPERATIONAL TEST SAT.SDR CALA2017081402705Power Supply · malfunctionedBATTERY FWD LT DISPLAYED DURING EMERGENCY LIGHT TEST. RESET FWD L EPSU AND PERFORMED OPS CHECK IAW AMM 33-51-38, OPS CHECKED GOOD, NO FURTHER DEFECTS NOTED.SDR CALA2017081402704Power Supply · inoperativeFOUND SEVERAL SEAT MOUNT EMERGENCY LIGHTS AND L2 DOOR 2L LT INOP DURING A SERVICE CHECK. REPLACED BATTERY AT RIGHT OVERWING AREA, CHKS GOOD. REPLACED THE 13WL POWER SUPPLY AFT LT, CHECKED GOOD. REPLACED THE LAMPS AT SEATS 25, 26, 29, 30, 34 AND DOOR 2L, EMERSDR CALA2017081402702Lens · missingEMERGENCY LIGHT HAS A MISSING LENS. REPLACED THE LENS.SDR CALA2017081402700Charger · inoperativeOVERHEAD INTERIOR EMERGENCY LIGHTS INOPERATIVE, ROWS 12BCA AND 11FED. REPLACED EMERGENCY LIGHT CHARGER ASSEMBLY. OPS CHECKED GOOD IAW AMM 33-51-06-960-806.SDR CALA2017081402698Battery Pack · inoperativeEMERGENCY LIGHT OUT AT SEAT ROW 12 ABC TO ROW 21 ABC. REMOVED AND REPLACED THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMALSDR CALA2017081402697Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017081402694Bulb · inoperativeL3 DOOR EMERGENCY EXTERIOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2017081402691Light · inoperativeEMERGENCY LIGHT AT SEAT 54H INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSY. OPS CHECK PASSED.SDR CALA2017081402690Light · inoperativeEMERGENCY LIGHT AT SEAT 57C INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT ASSY. OPS CHECK PASSED.SDR CALA2017081402688Light · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEAT 34C. REPLACED EMERGENCY LIGHT STRIP. OPS CHECKED GOOD IAW AMM 33-51-12-201. OPS CHECKED IAW AMM 33-51-12/201. OPS CHECKED GOOD.SDR CALA2017081402703Light · intermittentEMERGENCY LIGHTS GOING ON AND OFF UNCOMMANDED. RESET THE SYSTEM, OPS OK IAW MM 33-51-00SDR CALA2017081402701Light · missingEMERGENCY EXIT LIGHT AT SEAT 10C MISSING.SDR CALA2017081402699Lens · missingSMALL EMERGENCY SIGN AT ROW 21A MISSING. INSTALLED A NEW LENS.SDR CALA2017081402696Light · brokenSEAT ROW 35 LEFT EMERGENCY LIGHT BROKEN. REPLACED LIGHT ASSY IAW AMM 33-51-05.SDR CALA2017081402693Sign · detachedL3 DOOR EXIT SIGN FELL OFF. SECURED THE SIGN, OPS CHECKED GOOD.SDR CALA2017081402692Lamp · burned outR2 DOOR SLIDE LIGHT BURNED OUT. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-04.SDR CALA2017081402634Battery Pack · inoperativeEMERGENCY AISLE AREA LIGHTS AT 24DEF AND 27DEF ARE INOPERATIVE. REPLACED CHARGER AND BATTERY PACK. OPS CHECKED GOOD IAW AMM 33 -51-06.SDR YENA201708140659Battery · no testAFT EMERGENCY LIGHT BATTERY 13WL FAILS EMERGENCY LIGHT SYSTEM TEST. R & R EMERGENCY LIGHT BATTERY 13WL IAW AMM 33-51-38, SYSTEM OPS CHECKED GOOD.SDR AALA201708169020Lens · detachedTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LENS DETACHED FROM LIGHT, AFT GALLEY, RIGHT SIDE. REPLACED AFT GALLEY RIGHT SIDE EXIT LIGHT LENS PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708169019Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE LEFT AFT GALLEY DOOR WAIST HIGH IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708169016Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT COVER MISSING AT LT ENTRANCE AT NR 1 EXIT DOOR. INSTALLED NEW EXIT COVER AT LT ENTRANCE AT NR 1 EXIT DOOR IAW AMM 33-50.00. OK FOR SERVICE.SDR AALA201708169009Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT BATTERY 12WL FAILED TEST. REPLACED BATTERY 12WL PER MM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170813005Light · missingAIRCRAFT WAS NOT GROUNDED. R2 EMERGENCY EXIT LIGHT COVER, MISSING. REPLACED EMERGENCY EXIT LIGHT AT R2 DOOR. PER AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350