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 DALA2017091106815Power Supply · inoperativeEMERGENCY LIGHT FAILED, INT LOADS AFTL, EXT LOADS AFTL & BATTERY AFTL ILLUMINATED. REPLACED THE EPSU 13WL AND SLIDE.SDR UIEA2017090901624Lamp · inoperativeEXTERIOR EMERGENCY LIGHTS INOPERATIVE. AT DOORS L2, AND R2. REPLACED THE LAMPS IAW AMM 33-51-16. OPS CHECKED OK.SDR DALA2017091006782Battery Pack · inoperativeDURING INSPECTION FOUND FWD LEFT PSEU EMERGENCY LIGHT INOPERATIVE. R & R THE FWD BATTERY PACK. CHECKED GOOD IAW AMM 33-51.SDR AALA201709119023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER PLATE ON RIGHT SIDE OF LAV L73 IS MISSING. REPLACED EMERGENCY LIGHT LENS COVER.SDR CALA2017090903112Battery · dischargedEMERGENCY LIGHT TEST FAILED AT PTP PANEL. REPLACED BATTERY AT EPSU 11WL NOW OP TEST OK FOR SERVICE REF AMM 33-51-38 PB401.SDR CALA2017090903110Battery Pack · dischargedEMERGENCY EXIT SIGN OVER COCKPIT DOOR NOT WORKING. REPLACED BATTERY PACK AND FOUR FUSES. OPS CHECKED GOOD.SDR CALA2017090903109Lens · missingLENS COVER MISSING FOR EMERGENCY PATH LIGHT AT CLOSET 712. SEAT 1B LENS MISSING ONLY. LIGHT OPS CK GOOD. REPLACED LENS COVER ON EMERGENCY LIGHT AT CLOSET 712.SDR CALA2017090903108Battery Pack · dischargedALL EMERGENCY EXIT LIGHTS AND SIGNS IN AFT GALLEY AREA DO NOT ILLUMINATE. REPLACED BATTERY PACK IN M1672 POWER SUPPLY AND IN M1673 POWER SUPPLY. EMERGENCY LIGHTS OPS CHECKS GOOD REF AMM33-51-06-960-805.SDR CALA2017090903107Battery Pack · dischargedEXTERIOR EMERGENCY EXIT LIGHT AT LT AND RT AFT ENTRY DOORS, DO NOT ILLUMINATE. REPLACED FUSE AND BATTERY PACK IN M1672 POWER SUPPLY AND JUST THE BATTERY PACK IN M1673 POWER SUPPLY. EMERGENCY LIGHTS OPS CHECK GOOD REF AMM33-51-06-960-804 AND AMM 33-51-06-960-80SDR CALA2017090903106Battery Pack · dischargedEMERGENCY LIGHT AT OVERHEAD STOWAGE BULLNOSE COMPT AT ROW 30ABC, 32ABC AND 38ABC, DOES NOT ILLUMINATE. REPLACED FUSE AND BATTERY PACK IN M1672 POWER SUPPLY. EMERGENCY LIGHTS OPS CHECKS GOOD REF AMM 33-51-06-960-804 AND AMM 33-51- 06-960-805.SDR CALA2017090903105Light · inoperativeEMERGENCY EXIT LIGHTED SIGN ABOVE FWD RT ENTRY DOOR, HAS 1 BULB THAT DOES NOT ILLUMINATE. REPLACED BULB (3071BPE). OPS CHECKS GOOD.SDR CALA2017090903103Light · malfunctionedCABIN EMERG LIGHTS CAME ON IN THE ENTIRE CABIN FOR 2 MINS AND THEN WENT OFF. ACCOMPLISHED OPERATIONAL TEST REF AMM33-51-00-710-801 EMER LIGHTS CK NORMAL ON GROUND.SDR CALA2017090903104Lamp · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS AND OPS OK.SDR CALA2017090903100Epsu · faultyEPSU 11WL FAULTED. R & R THE EPSU.SDR MASA2017090912613Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED THE ACFT BATTERIES.SDR SWAA2017092816731Battery · dischargedEMERGENCY LIGHT BATTERY M1669 INOP. R&R BATTERY PER AMM.SDR HNAA2017091400307Light · inoperativeEMERGENCY LIGHT NOT ILLUMINATING. CLEANED AND RESEATED EMERGENCY LIGHT, OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA201709129003Light · looseAIRCRAFT WAS NOT GROUNDED. FIRST CLASS GALLEY EMERGENCY EXIT LIGHT AT THE FORWARD EDGE OF CART HOUSING 371 IS LOOSE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709129002Light · brokenAIRCRAFT WAS NOT GROUNDED. L2 DOOR AFT EMERGENCY EXIT LIGHT IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA201709119002Sign · brokenAIRCRAFT WAS NOT GROUNDED. DURING INSPECTION, MAINTENANCE FOUND LAVATORY L EMERGENCY PATH MARKER FLOOD LIGHT BROKEN. REPLACED EMERGENCY PATH MARKER FLOOD LIGHT PER AMM 33-51-18.SDR AALA201709119001Sign · brokenAIRCRAFT WAS NOT GROUNDED. DURING INSPECTION, MAINTENANCE FOUND LAVATORY D EMERGENCY PATH MARKER FLOOD LIGHT BROKEN. REPLACED EMERGENCY PATH MARKER FLOOD LIGHT PER AMM 33-51-18.SDR SWAA2017091216288Cover · missingL1 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS COVER MISSING. INSTALLED COVER PER AMM.SDR DALA2017090800007Lamp · inoperativeEMERGENCY LIGHTS INOPERATIVE AFT OF RIGHT WING X2. REPLACED THE LAMPS, OK.SDR YENA2017090800759Epsu · failedEPSU 15WL FAULTING ON WEEKLY CHECK. R & R THE EPSU AND BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR AALA201709119005Light · inoperativeEMERGENCY LIGHT SEAT MOUNTED ROW 7L INOPERATIVE. REPLACED LIGHT ASSY PER AMM.SDR DALA2017091106814Light · damagedFOUND THE EMERGENCY LIGHT AT SEAT 18C DAMAGED, REPLACED THE LIGHT ASSEMBLY.SDR DALA2017091006813Battery Pack · inoperativeEMERGENCY BATTERY FAULT ON LIGHT TEST, REPLACED BATTERY PACK.SDR YENA201709080758Battery · no testDURING T/C A320-33-51-00-710-003 BATTERY 10WL FAILED CAP TEST. EMERGENCY POWER SUPPLY UNIT & BATTERY FAILED TEST AT LOC 11WL. DURING T/C A320-33-51-00-710-003 BATT 12WL FAILED CAP TEST. EMERGENCY POWER SUPPLY UNIT AT 13WL FAILED SYSTEM TEST; R & R BATT 10WL IASDR YENA201709080757Battery Pack · no testBATTERY 12WL FAILED A CAPACITY TEST. R & R THE BATTERY IAW 33-51-38 TESTED NORMAL. OPS CHECKED GOOD.SDR YENA201709080756Power Supply · no testEMERGENCY POWER SUPPLY UNIT & BATTERY FAILED TEST AT LOC 11WL. R & R THE EPSU & BATTERY AT 11WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201709080755Battery Pack · no testDURING T/C A320-33-51-00-710-003 BATTERY 10WL FAILED A CAPACITY TEST. R & R THE BATTERY IAW 33-51-38. TESTED NORMAL.SDR YENA201709080754Battery · failedDURING T/C A320-33-51-00-710-003, BATTERY 10WL FAILED A CAPACITY TEST. R & R THE BATTERY IAW 33-51-38. TESTED NORMAL.SDR YENA201709080753Battery Pack · failedDURING T/C A320-33-51-00-710-003 BATTERY 10WL FAILED A CAPACITY TEST. EMERGENCY POWER SUPPLY UNIT & BATTERY FAILED TEST AT LOC 11WL. R & R THE BATTERY 10WL IAW 33-51-38. TESTED NORMAL. R & R EPSU & BATTERY AT 11WL IAW AMM 33-51-38, OPS CHECKED GOOD. R & R SDR AALA201709119022Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT AT SEAT 24G BROKEN. REPLACED EMERGENCY LIGHT AT SEAT 24G.SDR JJBA20170908002Light · inoperativeEMERGENCY EXIT SIGN ROW 18 WILL NOT ILLUMINATE. R & R EMERGENCY EXIT SIGN AND SPLICED WIRES TO CONNECTOR.SDR CALA2017090803092Lamp · inoperativeEXTERIOR RT FWD EMERGENCY HATCH ESCAPE LIGHT IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL IAW AMM 33-00-00SDR CALA2017090803091Battery Pack · inoperativeEMERGENCY STOW BIN LIGHTS ON RIGHT SIDE ARE INOPERATIVE AFT OF ROW 29. REPLACED THE BATTERY PACK, OPS CHECKED NORMALSDR CALA2017090803090Battery Pack · faultyEMERGENCY EXIT LIGHTS INOPERATIVE AT THE L1 DOOR AND FLIGHT DECK DOOR HEADER. INSTALLED A SERVICEABLE BATTERY PACK, IN THE CEILING AT THE L1 DOOR IAW AMM 33-51-06. LIGHTS OPS CHECKED GOOD.SDR CALA2017090803088Power Supply · faultedEMERGENCY LIGHTS AT SEAT 7ABC TO 14ABC DO NOT ILLUMINATE WHEN TESTED. FOUND THE M1676 POWER SUPPLY AT FAULT. REMOVED AND REPLACED THE POWER SUPPLY IAW MM 33-51-06-960-806, AND THE BATTERY PACK IAW MM 33-51-06-960-805. OPS CHECKED GOOD.SDR CALA2017090803087Switch · no testEMERGENCY LIGHTS WILL NOT TEST WITH PUSH BUTTON AT THE L1 DOOR. REMOVED AND REPLACED THE SWITCH S10292 IAW WDM 33-51-01. OPS CHECKED GOOD.SDR CALA2017090803084Lens · brokenSEAT 19C EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS. LIGHT WORKS NORMALLY. OPS CHECKED GOOD IAW AMM 33-00-00.SDR CALA2017090803079Light · inoperativeSEAT 35HJK EMERGENCY LIGHT INOPERATIVE. REPLACED SEAT LIGHT ASSY IAW AMM 33-51-12. OPS CHECKED GOOD.SDR CALA2017090803078Lens · missingSEAT 27F AISLE EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-06, OPS CKECKED GOOD.SDR CALA2017090803089Sign · looseEMERGENCY EXIT SIGN OVER THE WINDOW FOUND LOOSE. SECURED THE LIGHT.SDR CALA2017090803083Sign · detachedR2 DOOR EMERGENCY EXIT SIGN FELL OFF THE MOUNTING. SECURED THE SIGN.SDR CALA2017090803081Light · inoperativeEMERGENCY LIGHT ON SEAT 35K INOPERATIVE. REPLACED THE LIGHT ASSY IAW 33-51-12-332, OPS CHECKED GOOD.SDR CALA2017090803058Lens · missing1ST CLOSET EMERGENCY LIGHT COVER MISSING. REPLACED LENS COVER.SDR YENA201709080742Battery Pack · failedEPSU 15WL FAULTED DURING A WEEKLY CHECK. R & R EPSU AND BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR YENA201709080741Epsu · failedEPSU 15WL FAULTING DURING A WEEKLY CHECK. R & R THE EPSU AND BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR SWAA2017091816387Lens · damagedL1 DOOR UPPER EXIT LIGHT LENS DAMAGED. R&R LENS PER AMM.
Back to JASC 3350