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 DALA2017021401199Fuse · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEATS 10-12, BOTH SIDES. REPLACED THE FUSE IN THE POWER SUPPLY M33098 IAW AMM 33-51-06.SDR R61A201702130121Light · inoperativeMAINTENANCE REPORTED THAT THE LEFT NR 1 EMERGENCY LIGHT STRIP DID NOT LIGHT UP. MAINTENANCE REMOVED AND REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR JJBA20170213010Battery · inoperativeEMERGENCY EXIT LIGHT AT ROWS 10 AND 20 INOPERATIVE. REMOVED AND REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR CALA2017021300365Unknown · malfunctionedEMERGENCY EXIT LIGHTS KEEP FLICKERING AT GATE IN ARM POSITION WITH EXTERNAL POWER CONNECTED WHEN I ARRIVED ON AIRCRAFT, EMERGENCY LIGHTS WERE NO LONGER FLICKERING. CYCLED EMERGENCY LIGHT SWITCH IN COCKPIT, OPS CHECKED GOODSDR CALA2017021300363Light · inoperativeRIGHT WING FWD OVERWING EMERGENCY LIGHT NOT WORKING. RELAMPED IAW AMM 33-51-04. OPS CHECKS GOOD.SDR CALA2017021300362Battery · dischargedFWD EMERGENCY LT OVER DOOR 1L INOP. REPLACED FWD EMER LT BATTERY AND CHARGER. OP CHECK GOO VERIFIED FWD LT DR EMERGENCY LT OPERATION. OP CHECK OK.SDR CALA2017021300361Battery Pack · dischargedTHE EMERGENCY ISLE PATH LIGHTING IN THE COACH SECTION IS INOP. R&R M1672 BATTERY PACK IAW AMM 33-51-06-960-805. REMOVED AND REPLACED BATTERIES M1671, M2626, M1670, AND M2503. OPS CK OK.SDR CALA2017021300360Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP AT THE L1 DOOR (INSIDE AND OUT). REPLACED BATTERY PACK ON M1675 AT STA 322 WL 291 LBL 7 PER AMM 3 3-51-06-960-805. OPS CHECK GOOD.SDR CALA2017021300357Battery Pack · dischargedEMERGENCY LIGHTS AT ROWS 22L THRU 28L INOP. REMOVED AND REPLACED BATTERY PACK AT SEAT 26ABC. REF AMM 33-51-06-960-805 C/W IDT REQUIREMENTS.SDR CALA2017021300366Power Supply · inoperativeEMERG PWR SUPPLY 10WL FAILED TEST. REPLACED POWER SUPPLY 10WL REF AMM 33-51-38.SDR CALA2017021300358Light · inoperativeEMERGENCY LIGHT INOP IN BULLNOSE ABOVE SEAT 26D. RELAMPED BULLNOSE ABOVE 26D.SDR AALA20170215024Sign · crackedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT SIGN AT ROW 14 AFT TOP AREA IS CRACKED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170215006Lens · missingAIRCRAFT WAS NOT GROUNDED. RIGHT OVERWING EMERGENCY EXIT SIGN IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA20170215004Light · damagedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 11C IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA20170215003Screw · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT SEAT 24DEF HAS A LOOSE SCREW. TIGHTENED SCREW IAW AMM 20-11-00. OPERATIONAL CHECK GOOD.SDR AALA20170215002Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR INBOARD SIDE IS LOOSE. REATTACHED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR REXA2017021200199Light · inoperativeDURING A ROUTINE CHECK, FOUND EMERGENCY LIGHTS INOPERATIVE. R & R THE LIGHT IAW AMM 33-51-01, OPS CHECKED OK.SDR DALA2017021401253Light · brokenEMERGENCY LIGHT AT SEAT 16C BROKEN, REPLACED THE EMERGENCY LIGHT HOUSING ASSY.SDR YENA201702120068Relay · failedPILOT REPORTED THAT ALL CABIN EMERGENCY LIGHTS REMAINED ON AND COULD NOT GET THEM TO EXTINGUISH. R & R RELAY 8WL IAW TSM 33-51-00. OPS CHECK PASSED.SDR SWAA2017021511895Lamp · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017021511892Light · brokenRIGHT OVERWING EMERGENCY EXIT LIGHT BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017021411862Lens · unsecureL1 DOOR "EXIT" LIGHT LENS FELL OFF. R&R LENS IAW AMM.SDR AALA201702139004Lens · brokenLENS ON EMERGENCY EXIT LIGHT BROKEN. INSTALLED EMERGENCY EXIT LIGHT LENS.SDR ASAA2017021219791Lamp · failedR2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR DALA2017021301191Bulb · inoperativeDURING A CHECK, FOUND ROW 15 EF EMERGENCY LIGHT ON SEAT INOPERATIVE. REPLACED THE BULBS IAW 33-23. OPS CHECKED OK.SDR SWAA2017021311831Lamp · inoperativeR2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SIMA20170212004Lamp · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A, OPS CHECKED GOOD.SDR AALA201702139013Light · no testDURING DAILY CHECK, FOUND EXIT SIGN ABOVE THE L4 DOOR INOPERATIVE. REPLACED THE LIGHT IAW AMM 33-51-11.SDR AALA201702139012Decoder · no testDURING DAILY CHECK, FOUND EXIT SIGN ABOVE THE L4 DOOR INOPERATIVE. REPLACED DECODER ENCODER UNIT B IAW AMM 23-73-74.SDR AALA201702139011Battery · no testEMERGENCY POWER SUPPLY BATTERY FAILED CAPACITY TEST. REPLACED THE BATTERY IAW AMM 33-51-38-400-801.SDR AALA201702139010Battery · no testEMERGENCY POWER SUPPLY BATTERY FAILED CAPACITY TEST. REPLACED THE BATTERY IAW AMM 33-51-38-400-801.SDR AALA201702139006Lens · missingAFT EMERGENCY LIGHT LENS MISSING. REPLACED AFT EMERGENCY LIGHT LENSSDR AALA201702139003Lens · missingEMERGENCY EXIT LENS COVER MISSING AT THE L2 DOOR. INSTALLED A NEW LENS.SDR AALA201702139002Lens · brokenL4 DOOR LOWER EXIT LENS BROKEN. REPLACED THE EMERGENCY EXIT LIGHT LENS.SDR AALA201702139001Lens · brokenEXIT LENS OVER THE RT AFT SERVICE DOOR FOUND BROKEN. INSTALLED A NEW LENS.SDR DALA2017021301177Lamp · inoperative8C SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2017021212600Light · inoperativeRT FLR LVL EMER EXIT SIGN BULB INOP ROW 13. RELAMPED.SDR MASA2017021212599Light · inoperativeLT FLR LVL EMER EXIT SIGN BULB INOP. RELAMPED.SDR CALA2017021200334Power Supply · faultyEMER LIGHTS FAIL SYS TEST. REPLACE EMER LIGHT AFT POWER SUPPLY. OPS CK GOOD. REF AMM 33-51-38-400-001-A & IPC 33-51-04-07SDR CALA2017021200332Cover · looseEMERGENCY AREA LIGHT DOES NOT TURN OFF. EMER EQUIP COVER SECURED LIGHT COVER. REF 33-00-00.SDR DALA2017022101394Light · damagedSEAT 18E HAS A BROKEN EMERGENCY LIGHT SHROUD. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW CMM 25-26-19. OPS CHECKED GOOD.SDR ASOA201702111212Light · wornDURING C CHECK, FOUND EMERGENCY LIGHT WORN. R & R THE LIGHT.SDR REXA2017021100201Sign · missingMID CABIN EXIT SIGN COMPLETELY MISSING. ONCE PAX DEPLANED, SEARCHED THE WHOLE CABIN AND FOUND THE EXIT SIGN AT OVERHEAD BIN.
RESECURED OVERHEAD EXIT SIGN IAW AMM 33-51-07SDR REXA2017021100197Battery Pack · inoperativeWHEN EMERGENCY LIGHT SWITCH IS ON. EMERGENCY LIGHT COMES ON BRIGHT TO DIM TO OFF. REMOVED AND REPLACED ALL FOUR BATTERY PACKS. PERFORMED OPERATIONAL TEST PASSED IAW AMM 33-51-04.SDR DALA2017021501256Light · inoperativeDURING INSPECTION, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHT BULB INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT IAW AMM 33-21. OPS CHECKED GOOD.SDR AALA20170214019Lens · missingAIRCRAFT WAS GROUNDED. FORWARD LOWER EMERGENCY EXIT LIGHT IS MISSING THE LENS COVER. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170214016Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE EXIT ROW IS DETACHED FROM THE CEILING. REATTACHED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170214009Sign · detachedAIRCRAFT WAS GROUNDED. OVERHEAD EMERGENCY EXIT SIGN RIGHT SIDE ROW 21 IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170213023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT LEFT FORWARD OVERWING DOOR HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017021301226Light · brokenPATHWAY LIGHT ON SEAT 30D IS BROKEN OFF MOUNTING. REATTACHED PATHWAY LIGHT TO SEAT ASSY AT 30D CKS GOOD.
Back to JASC 3350