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 CALA2018102702198Battery · lowL4 DOOR & R4 DOOR EMER LIGHT CAPACITY CHECK & LT, 15MIN. REPLACED THE L4 DOOR & R4 DOOR EMER LIGHT M33408 & M33407 BATTERY AND C/O EMER LIGHT CAPACITY CHECK FOUND NORMAL REF AMM 33-51-06-20 0-801.SDR SWAA2018102926332Battery Pack · dischargedRT CENTER EMERGENCY LIGHTS INOP BETWEEN BS 603 TO BS 727C. R&R BATTERY PACK IAW AMM.SDR SWAA2018102926325Battery Pack · dischargedLT CENTER EMERGENCY LIGHTS INOP BETWEEN BS 603 TO BS 727C. R&R BATTERY PACK IAW AMM.SDR SWAA2018102926302Mount Bracket · missingCENTER CABIN AISLE EXIT LIGHT MOUNTING BRACKET MISSING. INSTALLED BRACKET PER SIP.SDR AALA201810299030Cover · dislodgedEMERGENCY LIGHT COVER AT THE L2 DOOR WAS DISLODGED. MAINTENANCE SECURED THE COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018102906325Lens · missingTHE EMERGENCY EXIT COVER DIFFUSER LENS IS MISSING AT 20C. MAINTENANCE REPLACED THE EMERGENCY EXIT SIGN LENS COVER. OK FOR SERVICE. (LP 0799210)SDR AALA201810299038Light · unknownEMERGENCY EXIT LIGHTS ARE ON IN ANY POSITION. CYCLED THE NO SMOKING LIGHT SWITCH. EXIT SIGN LIGHTS OPS CHECKED GOOD IAW AMM 33-50-00.SDR SWAA2018102626270Cover · missingCENTER CABIN CEILING EMERGENCY EXIT SIGN MISSING COVER ON ONE SIDE. REINSTALLED COVER SIS.SDR SWAA2018102626266Lens · missingL1 DOOR LIGHTED EXIT SIGN MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2018102626265Lens · missingL2 DOOR EMERGENCY EXIT LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2018102626258Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR CALA2018102702192Battery · dischargedCABIN R3 DOOR EMER LT PWR PACK BATTERY CANNOT BE CHARGED. CABIN R3 DOOR EMER LT PWR PACK BATTERY (M33401) REPLACED AND INSTALLATION TEST CARRIED OUT WITH NORMAL RESULT AS PER AMM 33-51-06.SDR CALA2018102702191Battery Pack · dischargedDOOR R3 EMER BATTERY PACK (M33404) CAPACITY CHECK FOUND FAIL. DOOR R3 EMER BATTERY PACK (M33404) BATTERY PACK REPLACED AND INSTALLATION TEST CARRIED OUT WITH NORMAL RESULT AS PER AMM 33-51-06.SDR CALA2018102702190Charger · inoperativeDOOR 3R EMER POWER SUPPLY M33404 BATTERY PACK FAILED TO CHARGE UP. DOOR 3R EMER PWR SUPPLY M33404 CHARGER REPLACED AND INSTALLATION TEST CARRIED OUT WITH NORMAL AS PER AMM 33-51-06.SDR CALA2018102702189Light · inoperativeC/O EMER LT TEST FOUND 41DEG SEAT EMER LT INOP. REPLACED THE 41DEG SEAT EMER LIGHT ASSY AND C/O EMER LIGHT TEST FOUND NORMAL REF AMM 33-51-05-960-802 REV 83.SDR R61A2018102651078Light · inoperativeEMERGENCY LIGHT IN 1ST CLASS INOP. R&R CABIN EMERGENCY LIGHT BY ROW 3 IAW AMM 33-50-13.SDR HALA2018102606315Sign · unsecureDOOR 3R EXIT SIGN FELL OFF. SECURED SIGN.SDR I5EA2018102600012Battery Pack · dischargedDISCREPANCY: EMERGENCY LIGHT OUT AT LT O/H BIN AT STA 727. CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY PACK AT STA 727L+13 IAW AMM 33-51-06, OPS CHECK GOOD.SDR QXEA2018102500386Sign · brokenFORWARD LOWER EXIT SIGN BROKEN AT THE TYPE II EMERGENCY EXIT. REPLACED.SDR DALA2018102506292Battery Pack · dischargedDURING INSPECTION FOUND FWD LT EMERG OUTSIDE LIGHT OUT. R&R FWD LT BATTERY PACK PER AMM 33-51. OPS CK ALL EMG. LTS OK FOR SERVICE.SDR DALA2018102506274Battery · dischargedAFT WINDOW EXIT SIGN LIGHT INOP BOTH SIDES. R&R AFT WINDOW EXIT SIGN BATTERY PER AMM 33-53. OPS CHECK GOOD.SDR DALA2018102506273Battery · dischargedROW 10-15 OVERHEAD EMER LIGHT OUT. R&R ROW 10-15 EMER LIGHT BATTERIES PER AMM 33-53. OPS CHECK GOOD.SDR DALA2018102506270Battery · dischargedEMERGENCY LIGHT IN AFT VENTRAL STARS OVERHEAD PANEL NOT ILLUMINATING. REPLACED BATTERIES IN EMERGENCY LIGHT POWER SUPPLY B5-28 IAW AMM 33-53.SDR FDEA201810242989Power Supply · inoperativeEMERGENCY LIGHTS WILL NOT TEST. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY REF AMM 33-51-01-4. OPS CK GOOD.SDR SIMA201811264002Light · inoperativePCR: EMERGENCY LIGHT STRIP IN FRONT OF CLOSET ON FLOOR DOES NOT ILLUMINATE FULLY-C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY LIGHT STRIP IN FRONT OF CLOSET ON FLOOR IAW EMB 175 AMM 33-50-21. OPS CHECK GOOD.SDR SWAA2018110226424Sign · crackedAFT LOWERED CEILING PANEL HOUSING EXIT SIGN ASSEMBLY CRACKED. R&R SIGN ASSEMBLY IAW AMM.SDR DALA2018103006393Bumper · damagedFOUND EMERGENCY FLOOR LIGHTING SEAT AISLE BUMPER DAMAGED AT 28B. REPLACED BUMPER. SYSTEM OPERATION IS NORMAL.SDR IPXA2018102535348Lens · missingLAVATORY AUXILIARY EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR SWAA2018102926303Lens · unsecureL1 DOOR LOWER EMERGENCY EXIT SIGN LIGHT COVER FELL OFF. REINSTALLED LENS PER AMM.SDR YENA2018102940706Light · malfunctionedFLT 993, BOS-DEN. UPON PREFLIGHT EXIT ROW LIGHT 10DEF REMAINS ON - END; RESET AND OPS CHECK OF EMER LIGHT SYS OK IAW AMM 33-50-00.SDR DALA2018102906333Epsu · inoperative(LP 0798099) EPSU (12WL) INOPERATIVE IN PASSENGER CABIN. REMOVED AND REPLACED SAME. OPERATIONS CHECKS OKAY.SDR SWAA2018102626256Battery Pack · failedLT OVERWING EMERGENCY EXTERIOR LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018102526244Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018102526243Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2018102526226Sign · missingR1 DOOR EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR SWAA2018102526225Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR DALA2018102506324Battery · faultedDURING EMERGENCY LIGHT TEST NOTED FAULT ON EPSU (11WL). REPLACED BATTERY.SDR AALA201810259025Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT INOPERABLE AT SEAT ROW 34. MAINTENANCE REPAIRED LIGHT AT SEAT ROW 34 PER ESPM 20-53-55 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR HALA2018102600547Sign · unsecure3R DOOR EXIT SIGN FELL OFF. SECURED SIGN CHECK OK.SDR AALA2018102659014Power Supply · inoperativeR4 OVERHEAD DOOR EMERGENCY BATTERY PACK WOULD NOT CHARGE. THE POWER SUPPLY ASSEMBLY M33409 WAS REPLACED AND PERFORMED SUCCESSFUL TEST IAW AMM 33-51-06-960-803.SDR HALA2018102500544Light · inoperativeDURING SERVICE CHECK FOUND 2R EMERGENCY LIGHT INOP. RELAMPED AND CONDITION SAME. 2R EMERGENCY LIGHT CEILING NEXT TO LAV. REPLACED EMERG PWR SUPPLY AND BATTERY PACK M1209, OPS CHECK OK PER AMM 31-51-07.SDR DALA2018102406296Light · inoperativeEMERGENCY LIGHTS ABOVE SEAT 16FG WON'T ILLUMINATE. MAINTENANCE FOUND LEFT ASSEMBLY DISCONNECTED AND SECURED. SYSTEM OPERATION IS NORMAL.SDR MASA2018102411471Light · inoperativeROW 16 OVHD EMERG FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2018102411473Charger · inoperativeROW 3 RT EMERGENCY EXIT SIGN INOP. R2 REPLACED NR 2 EPSU BATTERY CHARGER.SDR DALA2018102406291Housing · brokenDURING INSPECTION FOUND EMERGENCY LIGHT HOUSING AT ROW 28DEF BROKEN OFF. REINSTALLED EMER LIGHT HOUSING IAW AMM 33-52-00. OPS CK GOOD OK FOR SERVICE.SDR AALA201810259017Lens · brokenAIRCRAFT WAS NOT GROUNDED. R4 EMERGENCY LIGHT LENS BROKEN. REPLACED LENS PER AMM 33-51-19.SDR DALA2018102406276Holder · damagedSEAT 28D EMERGENCY MOUNTED LIGHT DAMAGED. REPLACED LIGHT HOLDER ASSY.SDR DALA2018102506272Battery · dischargedAFT OVERWING EMERGENCY DOOR EXIT LIGHTS INOP. T-S AND REPLACED CABIN OVERWING EMERGENCY DOOR LIGHTS BATTERY POWER SUPPLY PER MM 33-53. MPN - 803900-1, SN OFF - 25854, SN ON - 98354. OPS CHK GOOD. OK FOR SVC.SDR DALA2018102506271Battery Pack · dischargedFIRST CLASS EMERGENCY CEILING LIGHTS INOP. R&R BATTERY IN THE EMERGENCY BATTERY PACK B5-100 PER MM 33-53. OPS CHK - GOOD. OK FOR SVC.SDR C77A2018102400001Light · inoperativeROW 6 CEILING EMERGENY LIGHT INOP. R&R ROW 6 EMERGENCY LIGHT IAW AMM 33-50-13. OPS CHECK GOOD. OK FOR SVC.
Back to JASC 3350