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 YENA201906105306Epsu · failedFT # 71, FWD GALLEY EXIT LIGHT INOP ( INTERIOR/EXTERIOR EMERG LT SYSTEM ); R & R EPSU UNIT PER AMM REF 33-51-38. MX4 UPDATED.SDR SWAA2019060733455Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER MM.SDR SWAA2019060733454Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER MM.SDR SWAA2019060733453Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. / R&R BATTERY PACK PER MM.SDR SWAA2019060733452Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER MM.SDR SWAA2019060733422Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. / R&R BATTERY PACK PER MM.SDR DALA2019060753437Fuse · failedEMERGENCY PATH LIGHTS INOP FROM SEAT 27D TO 32D. REPLACED FUSE AT POWER SUPPLY M10568. EMG LIGHTS CK GOOD. OK FOR SERVICE.SDR UIEA2019060764404Battery Pack · inoperativeON INSPECTION, FOUND LEFT & RIGHT OVER WING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK IAW B767 AMM 33-51-07. EMERGENCY EXIT LIGHTS OPS CHECK NORMAL IAW B767 AMM 33-51-00.SDR UIEA2019060764405Bulb · inoperativeON INSPECTION, FOUND LEFT EXT EMERGENCY 2 AFT LIGHTS INOP.(<P>REPLACED BULBS FOR LEFT AFT EXT EMERGENCY LIGHTS IAW B767 AMM 33-51-01. OPS CHECK NORMAL.</P>)SDR HNAA2019060700161Bulb · inoperativeR/H FWD EMERGENCY LIGHT WILL NOT TURN ON. REMOVED AND REPLACED LIGHT IAW AMM 33-50-10-04 AND 33-50-00-700-801-A. OPS CHECK GOODSDR SIMA201906065002Inverter · inoperativeFROM SEATS 8A TO 11A [FLOOR STRIPS 4&5] FLOOR EMERGENCY PROXIMITY LIGHTS INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT DC/AC INVERTER 5 IAW AMM 33-50-11,OPS TEST GOOD.SDR UIEA2019060604406Light · inoperativeON INSPECTION, FOUND FLT DECK EMERGENCY EXIT LIGHT INOP. OPERATIONAL CHECK OK IAW B767 AMM 33-51-00-715-200.SDR DALA2019060603431Power Supply · malfunctionedEXIT LIGHT OVER TAILCONE EXIT AND AIRCRAFT RIGHT STANDBY EMERGENCY LIGHT FLICKER INTERMITTENTLY DURING ALL PHASES OF FLIGHT. MAINTENANCE RE-SET AFT POWER PACK AND THE FLICKER CEASED. OPERATIONAL CHECK WAS GOOD REF B717 AMM 33-51. (LP #6285367)SDR DALA2019060603430Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS: 604. MAINTENACE REINSTALLED THE CABIN SIDEWALL LIGHT LENS, (LT SIDE).SDR DALA2019060603413Battery Pack · inoperativeEMERGENCY LIGHTS INOP IN AFT GALLEY AREA. REPLACED BATTERY PACK UNDER RIGHT AFT FLIGHT ATTENDANT SEAT. SYSTEM OPERATION IS NORMAL.SDR MASA2019060511893Light · inoperativeAFT CABIN CEILING EMER LIGHT INOP.SDR SWAA2019062834284Lens · damagedR1 DOOR OVERHEAD EMERGENCY LENS DISCOLORED. R & R LENS IAW AMM.SDR SWAA2019062834278Lens · fadedL1 DOOR OVERHEAD EMERGENCY LENS DISCOLORED. R & R LENS IAW AMM.SDR SWAA2019062834272Lens · damagedR2 DOOR EMERGENCY LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019062834270Lens · damagedL2 DOOR EMERGENCY LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019062834269Lens · damagedFORWARD ENTRY CENTER LOWERED CEILING PANEL EXIT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019062734242Lens · damagedL2 DOOR EXIT LIGHT LENS DISCOLORED. / R&R LENS IAW AMM.SDR SWAA2019062734213Lens · damagedR2 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR HALA2019061260102Sign · unsecureDOOR 3R EXIT SIGN ON CEILING FELL OFF. RESECURED DOOR 3R EXIT SIGN. LP 5881247SDR YENA201906104304Lens · missingFT 1796, L1 DOOR EMERGENCY EXIT LIGHT COVER MISSING; RE-SECURED L1 DOOR THRESHOLD EMERGENCY EXIT LIGHT ASSY PER AMM. CHECKS OK.SDR REXA2019060740813Battery Pack · inoperativeDURING PRE FLIGHT INSPECTION EMERGENCY EXIT LIGHTING ON THE LOWER SIDE WALL AT ROW 13 FOUND TO BE INOP ON BOTH SIDES. REPLACED BATTERY PACK (EMERGENCYLIGHTS) AT PS 38 IAW CRJ 900 AMM 33-51-17 OPS TEST GOOD THIS CLEARS MEL MM02 UPDATED PLACARD REMOVED MOC NOTISDR SWAA2019060733407Sign · looseMID CABIN EXIT SIGN KNOCKED LOOSE. INSTALLED SIGN PER MM.SDR DALA2019060650103Housing · damagedDURING FAA WALK THRU, FOUND DOOR 1R LAV WALL MOUNTED EMERGENCY LIGHT COVER MISSING. DEFERRED PER MEL 33-50-07A, REPLACED WALL MOUNTED EMERGENCY LIGHT HOUSING. LP 5713968SDR ASOA2019060644026Light · inoperativeIAH - FLIGHT 4396 THE CREW REPORTED THAT THE EMERGENCY AISLE PATH LIGHTING AT ROW 8 & 9 WAS INOPERATIVE. MAINTENANCE INSPECTED THE AIRCRAFT, AND PLACED THE LIGHTS ON MEL33-50-00-2 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019060653417Lamp · inoperativeDOOR 1 LEFT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED DOOR L1 EXTERIOR EMERGENCY LIGHT FILAMENT. SYSTEM OPERTION IS NORMAL.SDR SWAA2019060633392Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT POSITION M1670. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019060633358Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT POSITION M1672. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019060633352Battery Pack · inoperativeR/H CABIN EMERGENCY LIGHTS INOPERATIVE. R&R BATTERY PACK PER AMM.SDR HALA2019060500277Sign · detachedEXIT 3R SIGN ON CEILING FELL OFF. SECURED 3R EXIT SIGN. OK FOR SVC.SDR SIMA201906054002Inverter · inoperativeFLOOR PROX LIGHTS 6,7,AND 8 INOP. T/S PER WM 33-50-50, R & R #6 INVERTER IAW EMB AMM 33-50-11-000-801-A AND 33-50-11-400-801-A OPC GOOD ENDSDR AALA201906059009Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AROUND FIRST CLASS GALLEY INOPERATIVE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY M33093 PER AMM 33-51-06.SDR AALA201906059008Power Supply · no testAIRCRAFT WAS NOT GROUNDED: LEFT MID EPSU INOPERATIVE. MAINTENANCE REPLACED LEFT MID EPSU PER AMM 33-51-38.SDR AALA201906054005Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY INSTALLED ABOVE DOOR 3R FAILED TEST. REPLACED POWER SUPPLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201906054004Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY AT DOOR 2R, FAILED TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201906054003Power Supply · failedEMERGENCY LIGHT POWER SUPPLY ASSY M33400 ABOVE DOOR 3L FAILED TEST., REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY ASSY M33400 ABOVE DOOR 3L IAW AMM 33-51-06, PERFORMED TEST FOUND GOOD IAW AMM 33-51-06.SDR MASA201906051891Bulb · inoperative14F LWR EMER EXIT SIGN BULB INOP. PLACED ON MELSDR SWAA2019061833887Cover · crackedG-1 GALLEY, EXIT LIGHT LENS COVER CRACKED. R&R COVER IAW AMM.SDR SWAA2019061833862Light · missingBOTH EMERGENCY EXIT EMERGENCY LIGHT LENS COVERS MISSING. / R&R LIGHTS IAW AMM.SDR DALA2019061213525Lens · looseEMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:604. REMOVED AND REPLACED EMERGENCY EXIT SIGN COVER LENS AT LOCATION 604, IAW AMM 33-51.SDR SWAA2019061133504Lens · missingL/H EMERGENCY EXIT BULLNOSE LIGHT COVER MISSING AT ROW 6. R&R LENS IAW MM.SDR FDEA2019060631217Battery · malfunctionedDURING PREFLIGHT NOTED L/H SIDE EMERG. LIGHTS AND EXIT SIGN SHORTLY ILLUMINATING. REPLACED BATTERY PACK ON POS. 1 ACC AMM 33-51-07-902-001 REV. 123.16 TESTED PER AMM. ALL WORKING SATIS.SDR R61A2019060630585Battery · inoperativeEMERGENCY LIGHT BATTERY FAULT ON EICAS. R&R FWD RH EMERGENCY LIGHT BATTERY IAW 33-50-01.SDR ASOA2019060634025Battery · looseIAH - FLIGHT 4442 THE CREW REPORTED THAT THE EXIT ROW EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE RECURRED THE #3 EMERGENCY LIGHT BATTERY, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019060633355Lamp · inoperativeR/H FORWARD SLIDE EXTERIOR LIGHT OUT. RELAMPED LIGHT PER AMM.SDR SWAA2019060633349Lens · missingL/H EMERGENCY EXIT BULLNOSE LIGHT COVER MISSING AT ROW 6. / R&R LENS IAW MM.
Back to JASC 3350